Year: 2023

Artificial intelligence visuals – Visualize and analyze the data

Artificial intelligence visuals As of this writing, Power BI has the following generally available artificial intelligence visuals: We review the key influencers and decomposition tree visuals separately in Skill 3.4: Identify patterns and trends. For the Q&A visual, refer to…

Use a custom visual – Visualize and analyze the data

Use a custom visual In addition to built-in visuals, Power BI offers a way to use custom visuals, or visuals created by using the Power BI SDK. There are two main ways to import a custom visual in Power BI…

Configure conditional formatting – Visualize and analyze the data

Configure conditional formatting Some formatting properties can be specified based on a condition, also known as expression-based formatting. If a property can be formatted conditionally, it will have an fx icon next to it, as shown in Figure 3-18, where…

Apply slicing and filtering – Visualize and analyze the data

Apply slicing and filtering One of the core features of Power BI is allowing report users to apply filters and see the values change in an instant. Filters can be applied in the following two ways: Slicers Slicers are visuals…

Filters pane – Visualize and analyze the data

Filters pane Besides slicers, you can apply filters by using the Filters pane on the right-hand side of the report, which has three sections: You can see the Filters pane in Figure 3-21. FIGURE 3-21 Filters pane. Filters in the…

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…