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" 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

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

        1) show all values on one graph 

        2) show percenatage 

         

        Like here: