Bar Chart to display parent and child on the same graph

[Fali324]

Hi,

I have a bar chart which the Y axis is a hieracrchy:
Sector 1
Sector 2

and my X axis is 
Sales 1
Sales 2

Is there a way I could display the parent (Sector 1) and the corresponding Sales values 1 & 2 and then below is the child nodes (sector 2) with their corresponding numbers for Sales 1 & 2 

Thanks

[rohit1991]

Hi @Fali324 

To display both the parent (like Sector 1) and child (Sector 2) nodes with their sales on the same clustered bar chart, the best native approach in Power BI is to build your hierarchy on the y-axis, add both Sector 1 and Sector 2 fields, and then use the “Expand all down one level in the hierarchy” option in your chart.

This way, you’ll see all parent categories and their children listed together, each with their corresponding Sales 1 and Sales 2 values.

If you’re looking for a way to show both levels side by side without drilling or expanding, Power BI’s bar chart doesn’t currently support that natively. However, the Matrix visual can display your hierarchy as rows and show sales figures side by side great for a more tabular view.

Another alternative is to restructure your data in Power Query so that each row represents both the parent and child, and then plot those as categorical bars, but for most cases the built-in hierarchy does the job nicely.

[v-aatheeque]

Hi @Fali324 ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Fali324 ,

If our response addressed by the  @Alex87 is resolved for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Alex87]

If you want to achieve the following result, you need to drill down into the hierarchy by clicking the highlighted button

[Fali324]

is there a way of displaying the parent without drilling down?

[Alex87 · Accepted solution]

In a clustered bar chart -> expanded all down one level in the hierachy option (as higlighted above) is the only way to display the 2 level hierarchy of the Y-axis

[v-aatheeque]

Hi @Fali324 ,

If our response addressed by the  @Alex87 is resolved for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!