How to show hierarchical data in clustered bar graphs

[Anonymous]

Hi All,

My data is in below format. How do I show a hierarchy of Cars with subvalues swift and bmw IN Clustered bar graph. I need to show bar graphs for bus, cars, swift and BMW all in one bar graph (Drilldown is not an option for me)

Category	Sales
Bus	1000 (Imagine Bar Graph)
Cars	2000 (Imagine Bar Graph)
1) Swift 2) BMW	1000 (Imagine Bar Graph) 1000 (Imagine Bar Graph)

Please suggest a way or any custom visual that can give this way.
Thanks,
Radhika

[v-yangliu-msft]

Hi  @Anonymous  ,

Your idea, power bi cannot support it temporarily

But you can see if this method works

Created some data:

Here are the steps you can follow：

1. Create a matrix visual object in Page1

2. Page2, select Type-Tooltip of Page Size. and Tooltip of Page information to ON.

3. Select the Stack bar chart to form the visual object

4. Select the matrix of Page1, set its Tooltip to ON, and set Page – Page2

5. Result.

The thumbnail of Page2 will be formed in the matrix. Which row is selected will display the Stack bar chart of the corresponding row.

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.

[Anonymous · Accepted solution]

Thanks Liu, this is a good solution. But my requirement was to show total and the split of subvalues for the total in this case, cars as total and also split of cars as bmw, honda and swift just below cars total. 
I have achieved by duplicating the clustered bar charts and placing it just below main category one. Not a perfect fix, but it solved the problem
Thanks again for the effort !

[amitchandak]

@Anonymous , Not very clear. But I think two columns(sort on both) and axis and concatenate label: off  can help

refer to my video: check power bi part: https://www.youtube.com/watch?v=2P5BBRN853c

[Anonymous]

Hi Amit

Thanks for replying but this how I want the visual to look like 
Cars is a hierarchy I made in power BI, with clustered bar chart it is showing either on lowest level with drill down or the top level i.e Buses, Trucks and Cars. I want to show it in the above way. Bar graphs represent Sales numbers for Actuals, Budget and Prior Year
Please suggest a way to get above visual in Power BI