Hi ...
I have created the below table and clustered bar chart output.
Based on the information below, how can I ensure that the Y-Axis value should follow the correct hierarchical position as in the table?
Thank you in advance.
Regards,
NickzNickz
Hello @NickzNickz ,
For this you have to create a order or index column for the management. This will help you in sorting.
After creating order column your data looks like this:
>> Then select Management column and in column tools click on sort by column and select order column.
Then output looks like this:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hi @NickzNickz
You have to add a column to allow you to sort by role.
Then to modify roles sort by this column from the data view:
Then put your data on graf sorted by role:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello @NickzNickz ,
For this you have to create a order or index column for the management. This will help you in sorting.
After creating order column your data looks like this:
>> Then select Management column and in column tools click on sort by column and select order column.
Then output looks like this:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
