Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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....
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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!
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      amitchandak
      Super User
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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"