This is a GAME CHANGER! Dynamic Switching Metrics in Visuals | Power BI

I found this amazing trick to update any visual, and any formatting, including conditional formatting and reference labels, when selecting a metric from its core measure using field parameters, and a lot of SWITCH 😀

🚫 Problem

I needed to create multiple KPI cards for a KPI Tree but each card had conditional formatting and various reference labels, so setting up just one was very time-consuming.

💡 Idea

Instead of recreating all measures and formatting the card every time, I wanted to create a filter for any measure to populate the visual so all I had to do was copy the card and change the filter to a different metric.

As you can see in the video, this worked not only with the card visual but any visual too 😃

🔗 Link to Power BI Report
https://app.powerbi.com/view?r=eyJrIj...

#PowerBI #DAX #PBICoreVisuals


🔗 Link to SQLBI article
https://www.sqlbi.com/blog/marco/2022...


📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/super...


▶️ Create KPI cards with Reference Labels
   • WOW with KPI Card Visuals using Refer...  


▶️ Create Guage / Target Charts
   • How to EASILY create gauge charts wit...  


🔖c h a p t e r s 🔖

00:00 - Intro
01:07 - How to create a field parameter
02:39 - Create measure to show selected name
05:07 - Create a 'selected measure' measure
06:24 - Add dynamic formatting to the measure
07:37 - Apply 'selected measure' to others
08:41 - Add text based conditional formatting
10:26 - Create dynamic chart titles
11:54 - Create variance with arrows measure
12:30 - Add dynamic measure tooltips
14:16 - Add a new metric to 'selected measure'
16:26 - Add a new metric to chart titles



💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter -   / deanchereden  

Middle School - The Way We Were https://chll.to/74bc13d3

🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felici...