Power BI Desktop – Visuals and Formats

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.
  

Basic knowledge of Power BI Desktop.