Forum Discussion

smohanty1987's avatar
smohanty1987
New Member
7 years ago

Sorting row with total for Matrix visualization

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!

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi smohanty1987 

     

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

    Please give Kudos for support.