Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.?
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.
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.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |