Power BI Desktop - Visuals and Formats

Basic knowledge of Power BI Desktop.

At the end of the course, candidates will be able to:

• Create visualisations and formats in Power BI

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 colour 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 analyse a data point compared to a target,
• Use the Gauge visual to analyse a data point compared to a target
• Create a custom KPI visual by combining other visuals.

AI Visuals

• Set up 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.