Forum Discussion
Only show rows depending on today's date
Hello, I have a visual that is a table and I want to filter it by rows depending on today's date. This is my visual. At the same time, I have a column in the Calendar Table that says: If...
Good morning, yes it is import mode and it is refreshed every day.
lbendlin
Super User
Super UserHere is the general pattern:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app