Dynamic Banding with continuous values

[vfsilva]

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.

[v-deddai1-msft]

Hi @vfsilva ,

Is there any update?

Best Regards,

Dedmon Dai

[v-deddai1-msft]

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

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