Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to figure out a way of filtering all the visuals on a page to default to today's date. I know that you can add this as a relative date filter, but if I do that, then I'm not able to select any other date besides today.
After some searching on Google and YouTube, I was able to create a measure that checks whether a date is 'today' or 'other date', and then add that into the report page as a slicer. However, you still have to pick 'other date' in order for other dates to be viewable.
Ideally, what I'm trying to achieve is for the report to default to today, without it restricting other dates from being picked, without having to use the slicer as a way of picking between the 2 options. Can anyone please help?
Thanks in advance!
Solved! Go to Solution.
Hi @Jaime_FOS ,
This may help you:
http://littledumbo.com/2019/05/23/how-to-set-default-value-for-slicers-in-power-bi-using-dax/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jaime_FOS ,
This may help you:
http://littledumbo.com/2019/05/23/how-to-set-default-value-for-slicers-in-power-bi-using-dax/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked perfectly! Thanks very much for your help 🙂
You can have a column like this
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"") //it will add date as text. if required use format to get date in a desired format
And sort this on the date column. As it derived from date it might sort
Date1 = Date
sort it on Date1.
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |