Use the Analyze in Excel feature – Visualize and analyze the data
Use the Analyze in Excel feature Power BI isn’t the only tool you can use to visualize data from Power BI datasets—you can use other tools, including Microsoft Excel. Once connected to a Power BI dataset in Excel, you can…
Create dashboards – Visualize and analyze the data
Skill 3.2: Create dashboards For the most part of this book so far, we’ve worked on building a Power BI report from a single dataset. This in itself can be one of the limitations of a report—it can contain data…
Card, multi-row card, and KPI – Visualize and analyze the data
Card, multi-row card, and KPI Besides the gauge visual, there are three other related visuals that can be used to display KPIs. The card visual has a single field well that accepts one field of any type, and it only…
Configure mobile view – Visualize and analyze the data
Configure mobile view A Power BI report has a desktop and mobile layout to cater for different screen sizes. Similarly, a dashboard has a web and a mobile layout (also known as a phone view). Figure 3-25 shows an example…
Add a Quick Insights result to a dashboard – Visualize and analyze the data
Add a Quick Insights result to a dashboard If you aren’t sure what to show in your reports or you want to check if you may have missed some insights, you can use the Quick Insights feature in the Power…
Add a dashboard theme – Visualize and analyze the data
Add a dashboard theme You can apply a theme to a dashboard similar to how you apply a theme to a report. This technique can be especially beneficial if you want to apply a uniform theme to a dashboard that…
Enhance reports for usability and storytelling – Visualize and analyze the data
Skill 3.3: Enhance reports for usability and storytelling Power BI reports can be made more user-friendly by adding bookmarks, tooltips, navigation, and interactivity, all of which we review in this section. Taking time to consider usability of your reports when…
Create custom tooltips – Visualize and analyze the data
Create custom tooltips Most Power BI visuals have default tooltips that show the values for a selected data point. In addition to this, Power BI allows you to set custom tooltips for each visual, which can be useful to provide…
Configure the report page – Visualize and analyze the data
Configure the report page You can change various page properties by selecting the Format pane after making sure that no visual is selected. You will then see the following sections: If you usually format your pages in certain ways, you…
Edit and configure interactions between visuals – Visualize and analyze the data
Edit and configure interactions between visuals One of the defining features of Power BI is the interaction of visuals with each other. For example, you can select an item in a bar chart, and it will cross-highlight a column chart….
