Distribution of data

[Anonymous]

Hello everyone, 

This is part of my data

I would like to show distribution of this data "Measure" and show on the column chart how many of measures falls into 0-10, how many 10-20 and so one... but since I used measure for it, it doesnt work with standard charts...

I would like to ask for adivce how to solve it. 

[amitchandak]

@Anonymous , Histogram or Segmentation should help

https://spreadsheeto.com/power-bi-histogram/

or

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Anonymous]

@amitchandakThank you for your reply 

I have tried and usually it works but since this is measure, im not getting any result.. I think. I have tried to make additional columns where I have "1" for values between 0 and 10 and "0" for other values. And didive in this was all my data points... but it doesnt work

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak  so here you can see: the "measure" is initial value, then "measure2" is where the value is less than 10 and "measure3" where the value is between 10 and 20. Just to strat with. And i wanted to show this on the graph - I chose cusered column chart with values "Measure2" and "Measure3" 

[Anonymous]

Hi @Anonymous,

Not quite sure whether it is what you want,see below:

Here is the .pbix file.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@AnonymousThank you, thats very good suggestion. But I would like to also:

1) show all values on one graph 

2) show percenatage 

Like here: 

[Anonymous · Accepted solution]

Hi @Anonymous ,

So is below what you need?

Here is the .pbix file.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!