Create a dynamic above & below selection group in Power BI
Creating 2 buckets, bin or groups based on a threshold can help pinpoint pain areas in the business, based on a metric, but knowing which threshold to set can mean many manual changes and requests from the business.
By making the threshold dynamic, this gives power back to the user, and I’ll show you how to create it in this video.
#PowerBI #DAX #BIAnalyst
📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/super...
🔗 Link to PBIX file
https://data.world/deanchereden/super...
🔖c h a p t e r s 🔖
00:00 - Intro
00:58 - Create a parameter selector
02:39 - Create a table for group names
04:00 - Create a filter to set if above or below
10:17 - Create a dynamic row name
10:42 - Create dynamic conditional formatting
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Ben Bada Boom - Frisky Feeling https://chll.to/e7cf01a6
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...