Forum Discussion

powerbidev123's avatar
powerbidev123
Solution Sage
1 year ago
Solved

Need help with table visual sorting

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?

 

 

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

    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