PBI Matrix - Sort on Col total value

[pbidani]

Hello All,

I need some guidance on how to sort a matrix by the total / sum of the column value.  

The above should be sorted by 14M, 12M, 11M, 4M.

The 3 dots on the top right of the matrix lets me sort y rows, not by the col total values.  

I will greatly appreciate your suggestions.

Thanks,

Pav

[Anonymous]

Hi @pbidani ,

Thanks for reaching out.

I reviewed your post and you requirement is that sorting the columns in a matrix, right?

Unfortunately, this feature is not available at this time.

Here're some similar ideas you can vote for:

Better Sorting in the Matrix Visual

Sort Column headers in Matrix

Best Regards,
Stephen Tao

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

[Ashish_Mathur]

Hi,

I'd like to try.  Please share the download link of the PBI file.

[pbidani]

 Thanks Ashish.

Much appreciated.

Attched is the link.

https://app.powerbi.com/reportEmbed?reportId=2f00193e-85df-4799-aa12-9c2a74554d7c&autoAuth=true&ctid...

This solution will help a lot.

Pav

[Ashish_Mathur]

That link takes me to a sign-in page.

[pbidani]

Hmmmm ....

How do i get the link / file to you?

Thanks,

Pav

[Idrissshatila]

Hello @pbidani ,

this functionality isn't yet available but you can vote for the idea to geet implemented.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=d7ca6e7c-2ffd-ec11-b5cf-501ac50aa17a