Forum Discussion
Sort Date and Value columns
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.
Thank you for the response.
The solution you suggested sorts the whole data by mixing the dates.
I would like to get the data sorted in such way that it example. for today it will show high to low value and if I select another date it will show high to low value. so on.
what i do not want: when i select today and tomorrow it should not mix the hours of these two dates while sorting high to low.
Currently as per your suggestion it will show today today tommorow today tommorrow tommorow.....
What I want Today High to low:
Tommorwo high to low.
sort should be limited to that day only.