This summary of the video was created by an AI. It might contain some inaccuracies.
00:00:00 – 00:19:01
The video demonstrates a technique to simulate dynamic theming in Power BI reports using bookmarks and images for different themes. The speaker discusses setting up color themes, creating measures for font and background colors, and customizing tables and visuals for visual appeal. They show how to change background colors, add bookmarks, and set actions for different shipping options. The video concludes by suggesting workarounds for limited properties in Power BI Desktop and encourages viewers to explore further resources on Enterprise DNA's website for Power BI learning opportunities.
00:00:00
In this segment of the video, the speaker discusses a technique to simulate dynamic theming in a Power BI report by using bookmarks instead of page navigation and images instead of page backgrounds. They demonstrate how to create a home page with buttons representing different themes for categories or modes of shipment. By clicking on the buttons, users can switch between different themes on the same page. The speaker explains the setup process, including adding a data set, finding images, generating a color theme, and creating DAX measures to customize the report’s appearance. They show examples of measures to return text and background or font color based on the chosen theme.
00:03:00
In this segment of the video, the speaker discusses setting up the color theme for a table, with varying colors based on category. They explain how to create measures for font color and background color that contrast well with the theme color. Following this setup, the focus shifts to building the solution by creating a home page and content page. The speaker demonstrates adding an image, slicer for categories, and a text box with a dynamic title based on category selection. The customization includes adjusting font and color settings for visual appeal.
00:06:00
In this segment of the video, the speaker demonstrates adding images and a table to a presentation. They first add images for each category with specific sizes and settings, naming them in the selection pane. Next, they add a table with information from the shipments table and key measures. The speaker then adjusts the formatting of the table, setting the title text and font colors. They also mention the dynamic change in the table title based on the slicer position.
00:09:00
In this part of the video, the focus is on changing background colors and adding bookmarks for images. Key actions include reorganizing elements on the page, turning images on and off for different sections, and adding bookmarks for each image. The speaker discusses adjusting transparency and layout to create an appealing visual design. The segment ends with a transition from the content page to the home page, where a blank button with an image fill is added.
00:12:00
In this segment of the video, the speaker adjusts the transparency of an image and changes a button to be a bookmark that redirects to another page. They set a transparent color for the title and background, naming everything for better organization. The speaker duplicates the button multiple times, adjusting each to represent a different category with specific fill and background colors.
00:15:00
In this segment of the video, the speaker demonstrates how to change the title background color, theme colors, and button fills for different shipping options on a webpage. They also show how to set actions for bookmarking categories like air, road, and rail, and navigate between pages. The speaker explains that currently, only specific properties can be set for the table visual in Power BI Desktop, but suggests a workaround using multiple visuals for each category. They speculate that more customizable properties may be available in future releases. They end by sharing a technique to simulate various themes until the feature is officially added.
00:18:00
In this segment of the video, the speaker thanks viewers for tuning in to Enterprise DNA TV and encourages them to like the video and subscribe to the channel. They mention a variety of content creators focused on improving the use of Power BI. Additionally, viewers are encouraged to visit Enterprise DNA’s website for resources and further learning opportunities related to Power BI and the Power Platform.