Скачать с ютуб This is a GAME CHANGER! Dynamic Switching Metrics in Visuals | Power BI в хорошем качестве

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...