Forum Discussion

Victormar's avatar
Victormar
Helper V
4 years ago

Distribution chart and column

Hi community,

 

I am facing a problem and I am not sure how to solve it in power bi.

 

I have a table with mileage readings (date) for some vehicles, and I would like to show the distribution of the mileage over the vehicles.

 

My first attempt would be to create a graph with buckets of mileage on the Y axis (0-11,100-200,200-300...) and on the X axis the count of how many days that particular vehicle was in each range, hope it makes sense.

In created a new column on the table with a switch function to classify every mileage reading, but I am not sure how to match it / count, for every vehicle, how many days has it been on every range.

 

Thanks in advance 🙂

 

 

Need Help

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    3 years ago

    Hi Victormar ,

     

    It's hard to tell what your data looks like. What kind of results do you need, please share some screenshots to help understand.

     

    Best Regards

    Community Support Team _ chenwu zhu

    • Victormar's avatar
      Victormar
      Helper V
      3 years ago

      Hi v-chenyue-msft,

       

      Thanks for your reply. It would be something like this:

       

      Not so good at paint sorry, but I came up with another solution that I thibk fullfills the demand:

       

      I created buckets for the mileage distribution, and then counted the number of days in every bucket 🙂

      The point was to see the distribution of mileage over days by every chassis.

       

      Thanks again for your time