Forum Discussion
Solved
Header sort in Matrix visual
Hi All, does anyone know how to sort the column header is the below matrix. It should be like 100%, 70%, 50% and then 40%. The Columns what I have used: -------------------------...
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 maverickf17,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.