Forum Discussion
Help Creating a Stacked bar graph with different subcategories
Hi all!
I'm fairly new to Power BI and was wondering if anyone had any insight into how I could make a single visualization with multiple bar graphs using the same data set, and with each bar graph displaying a progressively smaller number of data, with different sub categories. Hopefully I'm using the correct wording, but essentially here is my situation:
- I have 18,000 rows of data that I want to group in two distinct Categories (lets call them A&B) and display in a stacked bar graph.
- I then want to show only the data in category A (say 17,000 lines) and divide that Data into new subcategories: Lets call them "A1,B1,C1" in another bar graph.
- I then want to show only the data contained in category B1 (say 8,000 lines) and break it down further into subcategories A2,B2,C3, etc.. in another graph.
- Finally, I want to show only category C3 and break it down into subcategory A3,B3,C3 in a final graph.
I've attached a picture I drew with what I'm thinking of doing. All the data comes from a single data set. Apologies on what I'm sure is a noob question but any help would be greatly appreciated. Thank you!
- Anonymous8 years ago
Hi Dbhuertac,
Maybe you can try to use hierarchy slicer to filter visual graph to display specific items.
Otherwise you need to write a measure with conditions as value field of visual, I think it is hard and complex to achieve.Sample: hide bars when drill down.(2 level)
How to hide bars when drilling down in the same visualization?
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi Dbhuertac,
Maybe you can try to use hierarchy slicer to filter visual graph to display specific items.
Otherwise you need to write a measure with conditions as value field of visual, I think it is hard and complex to achieve.Sample: hide bars when drill down.(2 level)
How to hide bars when drilling down in the same visualization?
Regards,
Xiaoxin Sheng