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, 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