Forum Discussion
Showing Data Values for multiple Divisions
I have 5 different divisions that each record time to the same 4 category types. How can I show in one bar graph, the total time each division spent on each category? Currently, each of the 4 categories shows the same total value for each division. Any suggestions?
Hi MWolf1010 ,
I created some data:
Here are the steps you can follow：
1. You can use clustered column chart visual.
X-axis -- [divisions]
Y-axis -- [Value] – Set Sum
Legend – [category types]
2. Result:
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi MWolf1010
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi MWolf1010 ,
I created some data:
Here are the steps you can follow：
1. You can use clustered column chart visual.
X-axis -- [divisions]
Y-axis -- [Value] – Set Sum
Legend – [category types]
2. Result:
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
