Forum Discussion
Histogram with dynamic bins
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
- Anonymous3 years ago
thanks this is finally resolved by manual hardcode some bin ranges in a new table
2 Replies
- AnonymousNot applicable
thanks this is finally resolved by manual hardcode some bin ranges in a new table
- amitchandakSuper User
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