Distribution chart and column

[Victormar]

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 🙂

[v-chenwuz-msft]

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]

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