Showing Data Values for multiple Divisions

[MWolf1010]

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?

[Anonymous · Accepted solution]

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

[Ritaf1983]

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/1447523