Forum Discussion
Header sort in Matrix visual
Hi, there's a circular dependency when you try to sort by Burn_Bucket by Sort Order, because in this table you have another column 'Burn Bucket' that depends on a measure [A_Actual_burn_%] which might create a loop.
I'd suggest creating a SortOrder table manually since it is quite small and connect it to your 'A_Backend_aggregation' with one-to-many, sort by this 'Burn_Bucket' by 'SortOrder' in this new table and use Burn_Bucket from this new SortOrder table for your Matrix visual.
https://drive.google.com/file/d/1tBzw_T1ZIHgh30cvzzGsbPm3K_oG_dZH/view?usp=sharing
Hi DataNinja777 ,
I tried this approach.
It's not working.
Pease find the link of the pbix file.
https://www.dropbox.com/scl/fi/swkvtqqi41nyab4y8ids6/Cash-Burn-Final-Arjun-IRL-291-6-DESKTOP-OFTK3GM.pbix?rlkey=uwyg412rx45xrdciu5zc42rgx&st=u41zd3tk&dl=0
---------------------------------
Please refer page number : Main_15-09-2025.
Thanks,
Maverick
Hi maverickf17 ,
As MasonMA mentioned, there will be a circular dependency issue when you try to sort the Burn_Bucket column by SortOrder field (SortOrder depends on the Burn_Bucket for SWITCH operation and Burn_Bucket depends on SortOrder for sorting). A quick way to overcome the circular dependency is to create a copy of Burn_Bucket, sort this new field by SortOrder and use this field in the visual instead. As PowerBI will treat this as a separate entity, you will not get the circular dependency issue.
Well this being said, this is a quick one-off solution and only to be used if you do not want an extra table in your data model. The method described by MasonMA is a more professional way to tackle this scenario and it will add an extra table in your data model though (do use DATATABLE to create this table instead of manually entering data so that you can edit the fields and logic easily in the future).
Hope it helps!