Creating A KPI Scorecard Report: Part 2

Video by: Reid Havens

In this multi-part series you'll learn techniques utilizing DAX, custom visualizations, and design techniques to create a great looking KPI Scorecard report in Power BI.

Part Two will show you how to create KPI cards that utilize UNICHAR icons to as performance indicators, and how to create a Sparkline. Both of these visuals will be imported from the custom visuals store as well.

Relevant Links:

Blog Post: Mat Allington's UNICHAR DAX

Creating A KPI Scorecard Report: Part 1

In this multi-part series you'll learn techniques utilizing DAX, custom visualizations, and design techniques to create a great looking KPI Scorecard report in Power BI.

Part One will show you how to create the first set of KPI cards as well as the title card for each metric.

Creating a DAX Measures Table In Power BI Or Excel

A common pain point when building data models is how to organize your DAX Measures. Learn a great way to organize your DAX measures by creating a table to pl...

Video by: Reid Havens

A common pain point when building data models is how to organize your DAX Measures.

Learn a great way to organize your DAX measures by creating a table to place them in using a semi-hidden feature in Power BI or Excel.

P3: Using Conditional Formatting With Text in Power BI Desktop

Video by: Reid Havens

Today’s topic covers how to apply Conditional Formatting using text in Power BI Desktop. Conditional Formatting recently got a feature update, that allows you to apply color formatting rules based on ANY DAX Measure. I recently encountered a business scenario that had me play around with this feature a bit, and I came up with a clever way to use this for a client. I’ve included below the embedded Power BI report, download link to the .pbix file, and links to other articles explaining the various features & design techniques I’ve applied in this report. Otherwise, enjoy the video!