Sort columns in Matrix

[skhanna]

Hi,

I am new to Power BI and will appreciate any help with my question.

So, I have a matrix that tells the Visits for Doctors at corresponding Hospitals,

I am able to sort the matrix at row level and able to achieve this result as shown below.

I would like to further sort this matrix at column level, and the final result should look like this,

Is there any workaround to this? Any help will be appreciated.

Thanks!!

[djurecicK2]

Hi @skhanna ,

 Please see this article for how to do custom sorting:

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

Please accept as solution if this answers the question- thanks!

[skhanna]

Hi @djurecicK2,

The columns here are dynamic so creating a custom order won't work out.