Best visual to choose

[rocky09]

I have the following data, which contains Vehicle Service information.   I am able to get Individual summary with totals, If I use table. But, struggling to get the same information in charts.

I want to see the below criteria in a visual other than table/matrix. (stacked chart  may be?).

1. How many vehicles serviced by each Person did on each date.

2. Count of each vehicle type  (like Jeep -2, Mini Bus -1 ) by Individual on each date.

Here is the data:

Which chart is suitabe in this situation where you need to show All Vehicle serviced by a individual on each date and count of each vehicle serviced by individual on each day.?

[Phil_Seamark]

You could always use the Bar visual but use a hierarchy on the Axis

one that goes ServiceBy/Vehicle and then a second chart the other way around.  Drill down fully and you will see a nice graphical depiction of your data.

[TomMartens]

Hey,

my current favorite for visualizing multi-variate categorical variables is the custom visual "Infographic Designer" that you can find here

On its support page there are detailed explanations - look for small multiples.

[v-shex-msft]

Hi @rocky09,

You can use matrix visual and drag Date and Services to Rows field, vehicle to Columns and Values field, then you will get what you want.

Regards,
Xiaoxin Sheng