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 the day of the month is Prior to (U-8), being U the last working day of the month and 8 the number of days that I subtract (also working days), I have the code 0; If the day of the month is Between (U8) and (U-4), following the same logic, I have the code 1.
Now in my table in the report view I want to filter by rows depending on that days. If I am Prior (U-8) I just want to show the this row (and so on):
I need your help on doing something to filter in my table the rows, knowing the today's date and knowing if it is prior (U-8), etc.
Thank you!
4 Replies
- lbendlin
Super User
Are you accessing your data source in import mode? If yes, how frequently are you refreshing it?
"Today" can mean a lot of things. Also keep in mind that the Power BI service runs on UTC.
Good morning, yes it is import mode and it is refreshed every day.
- lbendlin
Here 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
Hello, sorry but i did not understand how that can help me with my visual to appear just the correspondent rows. Thank you
