Forum Discussion
Need help with table visual sorting
Hi amitchandak , Bibiano_Geraldo , ToddChitt
I have these columnsI 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?
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
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?