How to create Dynamic Multiple Range Groups in Power BI

Creating bin / bucket groups and manually updating them can be a very time consuming task, even more so if the banding isn't known or changes all the time.

In this video I show you how to create dynamic groups using 2 sliders, one to set the mid point and the other to create deviations sized groups either side of the mid point, so users can select whatever bin / bucket range they want to group the data by.

#PowerBI #DAX #BIAnalyst
📁 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
🔗 Link to PBIX file
https://data.world/deanchereden/superstore-dataset/workspace/file?filename=Dynamic+Multiple+Range+Group.pbix
🔖c h a p t e r s 🔖

00:00 - Intro
02:56 - Create numeric range parameters
04:48 - Create groups for your ranges
06:56 - Create a filter to apply to groups
16:17 - Create dynamic group names
21:44 - Create a conditional format for above & below
24:20 - Hide group total
25:06 - Adding additional metrics for insights
💌 My email - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden

🎵 Ben Bada Boom - Frisky Feeling https://chll.to/e7cf01a6

🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4

Видео How to create Dynamic Multiple Range Groups in Power BI канала Dean Chereden