How to change the desc order for only 1 line and add an average column only for the total?

[fcarvalho75]

Hi,

I have a table that must be desc order, however the first line (others) is the greater value, but I would like to have only in this case when Consultant Name is Others, automatically shows as the last line on the table. Is this possible?

Also, I would like to add a column after TOTAL called Average, but this column must be only the average of Grand Total, not every month. Is this possible?

Thanks a lot,

Fernanda

[Eric_Zhang · Accepted solution]

@fcarvalho75

You can do that sorting by a workaround using an aggregated table. Check more details in  the attached pbix file.

OrderTable is a reference from yourTable

You can check the similar sorting in Sorting Data Manually .

As to adding a extrat column to matrix visual, AFAIK, it is not supported. You can check this idea Add Personalized Columns in Matrix and vote it up.