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.
I have Calculated Dates filter and slicers and It is perfectly working fine.
I even added a TODAY filter that only filters based on today's data.
But the problem is that whenever i open the report it keeps the same dates as before (the slices doesnt get updated based on todays date).
I want the to set the default dates for the slicer to be for today whenever the dashboard opens.
for example:
If the report opens today, then FromDate in the slicer is 1-Jan-2021 & ToDate is 16-Feb-2021
If the dashboard viewed tomorrow then FromDate in the slicer is 1-Jan-2021 & ToDate is 17-Feb-2021.
Solved! Go to Solution.
@Anonymous
@Noor_Rahmeh , There is no way to default. You need to create a flag(new column) like this in the date table and use that as filter
Is This Year = if('Date'[Date]>=date(Year(TODAY()),1,1) && 'Date'[Date]<=TODAY(),"This year",[Date]&"")
check : https://youtu.be/hfn05preQYA
Hi @Anonymous ,
You could create a measure as below.
Measure = IF(SELECTEDVALUE('Table'[date])<=TODAY(),1,0)
Then add it to visual level filter.
Best Regards,
Jay
@Anonymous
@Noor_Rahmeh , There is no way to default. You need to create a flag(new column) like this in the date table and use that as filter
Is This Year = if('Date'[Date]>=date(Year(TODAY()),1,1) && 'Date'[Date]<=TODAY(),"This year",[Date]&"")
check : https://youtu.be/hfn05preQYA
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |