Forum Discussion

gaikwadaa123's avatar
gaikwadaa123
Icon for Helper II rankHelper II
5 years ago

Sort Date and Value columns

Hello,  I have a data that looks like below:   I would like sort the DEP, DEC and DOM column in descendig order for whatever the date range EST (Datetime )Column is selected.  Example  if ...
ORDER
sort
sorting
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

No DAX is needed for this. In your table in Power BI (I assume you are using a table visual - you didn't say) just select first by DEP. Then press SHIFT and sort again by DEC, then finally DOM. Now those 3 columns are sorted as you like. Changing what dates show up won't affect those sorts, just the records visible.

If that isn't what you want, please be more specific. The image you show is from Power Query, and end users don't work in Power Query so sorting there will have no effect on a report.