Sorting row with total for Matrix visualization

[smohanty1987]

Hello All,

I'm new to the forum and pretty new to Power BI. I've been creating the PBI dashboards now and have a request from my manager to sort one column and include the total row. See below:

As this is sensitive information, I have to unfortunately white-out the names of the brands associated. The Total here is a feature of the Matrix visualization. Currently the table is sorted based on the YoY % column. 

My question: is it possible to include the Total row in the sorting of the column. So, in this sense the Total row would be right above the 7.3% row. 

Any advice would be much appreciated.

Thanks!

[mwegener]

Hi @smohanty1987 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[v-yuta-msft]

Hi smohanty1987,

I'm afraid you couldn't directly add an average value to the existed percentage column, however, as a workaround, you may create a calculate column to achieve the average value and add the calculate column to the matrix chart.

Regards,

Jimmy Tao

[mwegener]

No.