Forum Discussion
Distribution of data
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.
- Anonymous6 years ago
Hi Anonymous ,
So is below what you need?
Here is the .pbix file.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
7 Replies
- amitchandakSuper User
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- AnonymousNot applicable
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
- amitchandakSuper User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.