Forum Discussion
Special Date Filter Sort Inquiry
I have a date filter in my power bi report. The end-user wants it to display all dates, but only show data for one at a time due to the model. The data refreshes daily so I cannot select most recent date. I did the following which works.
This can be closed. This video explains it and was easier than I thought. I left the column as is with TEXT format. Then sorted by column in the formula by the actual date column. Here is a vid explaining it. Thanks for your help. Appreciate it.
3 Replies
This can be closed. This video explains it and was easier than I thought. I left the column as is with TEXT format. Then sorted by column in the formula by the actual date column. Here is a vid explaining it. Thanks for your help. Appreciate it.
instead of "1-" use " " (a single space). If Power BI gets cute and trims that, use any other character that comes before "1".
You would also want to format your dates in sortable way, like "YYYY-MM-DD".
THe first part fixes the sort but now I have two different variant types in the column. 1 is the 0-Most Recent which will automatically have the slicer adjusted to the recent day on refresh. Then the dates are all text. I cannot convert them in this column. I just want an easy way for the data to refresh and have the slicer single select the most recent date on daily refresh. The only way I saw this done was to give it a name like 0-Most Recent but now it is causing other issues.
