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
app.powerbi.com/view?r=eyJrIj...
#PowerBI #DAX #PBICoreVisuals
🔗 Link to SQLBI article
www.sqlbi.com/blog/marco/2022...
📁 Dataset for Sales Data and file for original dim date table M code
data.world/deanchereden/super...
▶️ Create KPI cards with Reference Labels
• WOW with KPI Card Visu...
▶️ Create Guage / Target Charts
• How to EASILY create g...
🔖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 - dean@deanchereden.com
🌍 My website - www.deanchereden.com
🐦 Twitter - / deanchereden
Middle School - The Way We Were chll.to/74bc13d3
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - ...