Multi level sort - not saving

[Anonymous]

Hi,

I have some quirky behaviour on my reports which I assume is user error on my part.

I have some graphs which are backed with some multi level sort in their respective table view. The mutli level sort works fine as expected.

However, whenever I alter the multi-level sort and change the table back into a graph etc, the mutli-level is reverted back. Its almost as if my changes to mutli-level do not save.

I have a workaround where I can just recreate the table/graph but then I have to do all the formatting again.

What am I doing wrong here?

Cheers,

Scott

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You need to customize the sort before you create the visual.

Please refer:

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi 

https://community.powerbi.com/t5/Desktop/Multi-level-custom-sort/m-p/295113 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.