I would like to know how I can filter a page of my PowerBI report automatically on the last date of my database.
I have created a basic measure MaxDate = MAX(DateColumn)
Then I have tried to drag this measure to my page filter.
But it doesn't work.
Do you know how I can solve this ?
Solved! Go to Solution.
You cannot use measures at the page filter level. You can use a calculated column at the page level however. I would suggest converting your measure to a calculated column first and see if your DAX translates to fit your issue.
Hi, ive tried this method, but seems its only shows max date on the filter slicer. how to make it also shows all dates, but will only select max date ? (especially when user access the link report, the page will automatically select max date, but still shows old dates)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.