Sort Matrix Columns in Descending Order - using a Switch Measure.

[billylo]

Hi all, I need help arranging the order of columns based on descending order when using "switched" measure ( Sales | Qty).

I have attached an image for your review. The current report side of the image shows what the table is doing at the moment

independently of the measure I select on the image. (it's arranging columns alphabetically)

The "Ideal report" side of the image depicts where I would like to get. The order of the columns should vary in descending oder based on the measure that is selected - Sales/Qty as noted above.

Thanks for your help!

[lbendlin]

That is far beyond what Power BI can do.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

[billylo]

Thank you for taking the time to respond & the suggestion.  I'll put this one forth.

WIll