Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have the following table and i want to filter only the dates up until today's date. That is, every time the report is refreshed, it should only show all the rows in the table up to today's date. In other words, all the rows with the dates after today's date should be hidden.
Any help would be much appreciated!
Date | Student Name | Submissions | Feedback |
03/01/2022 | Lizui | 4 | 2 |
06/01/2022 | Laufenburg | 7 | 5 |
11/01/2022 | Tegalpapak | 8 | 8 |
12/01/2022 | Ar Rabiyah | 5 | 6 |
22/01/2022 | Bellegarde | 3 | 8 |
21/01/2022 | Gangarampur | 3 | 3 |
25/02/2022 | Luntas | 1 | 1 |
26/02/2022 | Frei Paulo | 6 | 5 |
26/03/2022 | Seedorf | 2 | 1 |
03/04/2022 | Bellegarde | 3 | 4 |
05/04/2022 | Gangarampur | 3 | 7 |
11/04/2022 | Luntas | 1 | 2 |
09/05/2022 | Cosamaloapan de Carpio | 7 | 3 |
15/05/2022 | Zagrodno | 9 | 9 |
I placed the table above into a table visualization in Power BI, as shown below. I am also trying to show the title of that table as dynamic with the last date that the data was refreshed. How to do this?
Solved! Go to Solution.
Hi @Anonymous ,
1. Create a flag measure,And apply it to filter pane , set as "is 1":
Flag = IF(MAX('Table'[Date])<=TODAY(),1,0)
2. Create a measure for dynamic header, and apply it to Title Text field in General pane:
Dynamic header = "Date refreshed on "&TODAY()
Final output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
1. Create a flag measure,And apply it to filter pane , set as "is 1":
Flag = IF(MAX('Table'[Date])<=TODAY(),1,0)
2. Create a measure for dynamic header, and apply it to Title Text field in General pane:
Dynamic header = "Date refreshed on "&TODAY()
Final output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the link for showing refresh date/time.
https://askgarth.com/blog/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/
You can use the refresh date/time as a benchmark, to select all the rows with time before this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |