Histogram with dynamic bins

[Anonymous]

Hi Experts,

I need to create a histogram of scores (ranging from 0 to 1), with selection of dynamic bins (as multiple of 0.025*, 4 selections - 0.025, 0.05, 0.075, 0.1), referring to the source How to create a dynamic histogram in Power BI with adjustable bins (datacornering.com) however i fail to do the same.

what if parameter with bin size :

the chart do not look quite right...

I tried to adjust some values in DAX but fail.....Might anyone could help? thank you

[Anonymous · Accepted solution]

thanks this is finally resolved by manual hardcode some bin ranges in a new table

[amitchandak]

@Anonymous , create a column for the bin in table

example

switch( True(),

[column] <.25. "  0 - .25",

[column] <.5. " 25 - .5",

// add other

"GT 1" //default

)

and use of axis

for meausre consider

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k