Power BI Desktop – Visuals and Formats

Goals

Learn about the visualizations and formatting in Power BI.

Prerequisite

Basic knowledge of Power BI Desktop.

Contents

Page format, Themes and Templates

• Format a page,

• Create a theme to change the overall look and feel of a report,

• Load an existing theme and edit it,

• Save a theme as a json file,

• Create a template.

Basic Visuals and formats

• Insert a visual and place it on the canvas,

• Basic formatting concepts (format pane, categories, etc.).

Tooltips

• Add additional fields in the Power BI default tooltips,

• Create a custom tooltip with Power BI visuals.

Conditional formatting and analytics

• Dynamically change the color of visual elements with conditional formatting,

• Add conditional formatting icons to your tables and matrices,

• Use Power BI’s analytics features to add constant lines, average lines, trend lines, etc. to your visual.

Drilldown & Drill-through

• Setup drilldown for report consumers,

• Create a drill-though page to show additional insight based on a particular field.

Target Analysis

• Use the KPI visual to analyze a data point compared to a target,

• Use the Gauge visual to analyze a data point compared to a target

• Create a custom KPI visual by combining other visuals.

AI Visuals

• Setup the Q&A visual to let users type natural language queries,

• Use the Key Influencers visual to identify the key influencers in your data,

• Use the decomposition tree interactive visual to explore data.