Forum Discussion
Dynamic Banding with continuous values
Hi folks.
I'm trying to do a dynamic banding graph. I have a column with values going from 0 to 100%. I want the user to be able to select dynamically a value of step, let's suppose 20% and a bar chart updates the bands to 20% size, so the graph would have 5 bars: 0 - 20%, 20% - 40%, 40 - 60%, 60 - 80%, 80 - 100%.
This step needs to be dynamically set, so the user should be able to 10, 15, anyway. The problem that I'm facing is that I am not able to connect this step value to the percentage values column.
I'm trying to that for a week and could not advance.
If some power bi brother could help me, I would be so grateful.
2 Replies
- v-deddai1-msftCommunity Support
Hi vfsilva ,
Are you talking about dynamic bin in power bi? You can refer to https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-count-of-bins
And if you need more help, please show us some sample data by onedrive for business.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
- v-deddai1-msftCommunity Support