Forum Discussion

maverickf17's avatar
maverickf17
Helper I
11 months ago
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: -------------------------...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MasonMA's avatar
    MasonMA
    11 months ago

    maverickf17 

     

    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