Need help with table visual sorting

[powerbidev123]

Hi Community,

I have a table visual that consists of A,B,C,date. I want to sort the date as per descending  order and at the same time I don't want to display it in my table visual. Now Table visual doesn't have a tooltip option where can I drag the date column to it and then sort the axis as per the date.

Any suggestion or workaround to solve this?

[amitchandak]

@powerbidev123 ,In the table visual, you can sort in descending order by clicking twice on the column or by using the ellipsis icon (three dots) and selecting "Sort Descending." The only issue occurs with the matrix visual when you have the date field on column, as that option is not available.

Then have two columsn like

Date1 = [Date]

Date Desc Sort  = rankx(Table, [Date],,desc,dense)

Now mark Date Desc Sort as sort column of Date 1 and use date1 on Matrix column sort

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[powerbidev123 · Accepted solution]

Hi @amitchandak , @Bibiano_Geraldo , @ToddChitt 
I have these columns

I dont want to show the createdon date column in the table visual but at the same time I want to sort it as well . How is it possible? 

[Bibiano_Geraldo]

Hi @powerbidev123 ,

Please give us more contex and picures of what youre facing

[ToddChitt]

Can you show us what you need with a screenshot?