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=eyJrIjoiMmVmNTc1NTQtY2I4Ni00OGNkLWI0OGEtNzRkNDc0MjU0OTdjIiwidCI6IjY5NjYzY2E5LTcyYTktNDgyYy05NmNhLTUyYWUxMThhODQ1MCJ9
#PowerBI #DAX #PBICoreVisuals
🔗 Link to SQLBI article
https://www.sqlbi.com/blog/marco/2022/06/11/using-selectedvalue-with-fields-parameters-in-power-bi/
📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/superstore-dataset/workspace/file?filename=PBI+Sales+Dashboard+-+Superstore+Dataset.zip
▶️ Create KPI cards with Reference Labels
https://youtu.be/XYJJgwDVVAQ
▶️ Create Guage / Target Charts
https://youtu.be/banwEaU03ek
🔖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 - https://twitter.com/deanchereden
Middle School - The Way We Were https://chll.to/74bc13d3
🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4