Forum Discussion
Creating a Bar Graph with Main Groups and Their Sub Groups
Hi Bridgewater,
If your problem is answered appropriately, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia
Hi Bridgewater,
I create the sample table in my Power Bi desktop, and get expected result, please review the following steps.
1. Create a new calculated column to display the Gruop, the original group shows the sub-group.
Group = LEFT(Table6[Sub-Group],1)
2. Create a Stacked column chart, select the Group as Axis, the sub-group as Legend, Sales as value. You will get the following result.
Best Regards,
Angelia
v-huizhn-msft Thank you so much for that help!
Separating the Main Groups and Sub Groups into different colums helped.
One more question. Is it possible to do what you did, but also have the subgroups as their own bar? Below is what I'm trying to acheive ultimately. This was done in excel and transfered to a word doc but it is way too time consuming, hence why I'm trying to use PBI for this. In this example, the dollar numbers aren't necessarily important, only that Group 2 is the combined value of Sub Group 2.1, 2.2, and 2.3. Those subgroups also have their own bar.
Thank you again
Hi Bridgewater,
Yes, you can create a clustered bar chart and select the sub-group as X-axis, the sales as value, please see more details in the screenshot below.
Best Regards,
AngeliaHi Bridgewater,
If your problem is answered appropriately, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia