In this module you will learn how to use the Multi KPI. The Multi KPI is great for displaying multiple KPI values in a single visual.

Module 117 – Multi KPI

Downloads

• Power BI Custom Visual – Multi KPI
• Dataset – Internet Sales.xlsx
• Completed Example – Module 117 – Multi KPI.pbix

Key Takeaways

• Great for displaying multiple KPI values in a single visual.
• The Multi KPI is a highly customizable visual.

This Multi KPI allows you to track a Sales Amount KPI with the supportive measures of Quantity, Cost, and Tax shown as sparklines.

Under the Format paintbrush you will find there are several customizations that you can enable for this visual.

• Using the Date section you can change the formatting of the date in the visual.

• Under the Values section you can change the formatting for each of the chart measure values.

• Using the Y Axis properties you can change the appearance of the Y Axis on each chart. You should know that by default only the main chart has a Y Axis that is visible.

• Changing the Main Chart section allows you to adjust the shading and style of the main chart on the top of this visual.

• The Tooltip section allows you to modify what is displayed for the tooltip on each measure.

• Modifying the KPI section adjusts the appearance of the main KPI display.

• The KPI On Hover can change the appearance of the KPI when a cursor hovers over the KPI.

• Turning on/off the Sparkline Grid property changes the default behavior where the KPI display can change when you hover over a sparkline.

• Use the Position property under the Sparkline section to change the order of the sparklines in the visual.

• Adjusting the Sparkline Name property allows you to customize the formatting on the chart name.

• Changing the Sparkline Chart section allows you to adjust the shading and style of each sparkline.

• Under the Sparkline Value section you can change the formatting for each of the chart measure values.

• Using the Sparkline Y Axis properties you can change the appearance of the Y Axis on each chart.

• The Subtitle section allows you to add text below all the charts to describe what the visual is displaying.

• Changing the Print Mode option makes the visual more print friendly when you select Export to PDF.

You can also adjust the background color, add a border around the visual and lock the aspect ratio under the Format section.