Sorting in matrix visual by Amount

[Charu]

Dear Community,

Hope all is well.

Could you help me with the scenario where I need to have sort the matrix visual by Amount?

In table visual, sorting by amount works well and good but the same is not working in Matrix visual.

I just played with the sample data to sort the matrix visual by Amount. Here is the screenshot for your reference

it's not showing the correct descending order sorting.

Please help me get the solution for this.

[amitchandak · Accepted solution]

@Charu ,  In Matrix visual , once you use column(pivot) then it will sort on column total only( Means Aug + sep Sum in this case) .

You can check and vote or log new idea :https://ideas.powerbi.com/ideas/

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.