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 multiple reports in which new data extract is added each month. I am currently choosing the latest extract date in the extract date slicer so I can see only the last extract data. However, due to I have many reports, it is time consuming to go to each report, go edit mode select the last date in extract date slicer and save the report. There is also the fact of human error to miss a report with the old extract date preselected.
Is there any way or a workaround that can sort this automatically? i.e. every time a new data extract is added the report to show the latest date extract data.
I am thinking, there may be a way with DAX or any other work around.
Many thanks!
Solved! Go to Solution.
Hi @Anonymous ,
The Below video shows a way to get the latest date always by storing it to text and it is always selected. Do check if it helps in your case
https://www.youtube.com/watch?v=c_MjL1Cngbs
Regards,
Many thanks this actually works!
I also found another source that solves the issue with a similar way.
powerbi - Default slicer selection (latest date) in Power BI - Stack Overflow
Hi,
could you meanwhile find a way which works in the way you want it to work?
The offered solutions limit the user's possibility to select other dates, which is my problem, too. So I would be interested in a "real" solution...
Thanks,
Christian
Hi @Anonymous ,
The Below video shows a way to get the latest date always by storing it to text and it is always selected. Do check if it helps in your case
https://www.youtube.com/watch?v=c_MjL1Cngbs
Regards,
Many thanks this actually works!
I also found another source that solves the issue with a similar way.
powerbi - Default slicer selection (latest date) in Power BI - Stack Overflow
Many thanks for the response Pat. I forgot to mention that the users should still be able to select previous months. I believe with the solution you mentioned. Users will not be able to do this due to the IsLatestMonth filter.
I would add a Date table to your model (that automatically expands when new data are added) and either use a relative time filter on the reports, or add a column to your date table with IsLatestMonth (and filter your pages to where IsLatestMonth = "Y".
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |