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.
Hi all
on many reports, I use a slicer to select dates, as in the screen shot below.
The slicer style is set to "Between".
On some reports, the 2nd date will automatically display today's date, when I open the file.
On other reports, the 2nd date will not automatically display today's date.
I can't figure out the difference.
Any idea, please?
@EVEAdmin , You need to use a workaround
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
new columns, needed in date table
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
Is Last 30 = if('Date'[Date]>=TODAY()-30 && 'Date'[Date]<=TODAY(),"Today",[Date]&"")
Is Last 90 = if('Date'[Date]>=TODAY()-90 && 'Date'[Date]<=TODAY(),"Last 90 Days",[Date]&"")
@amitchandak thank you, appreciated.
I added this column to my Calendar table:
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
However, when I add the column to the slicer, then I loose the option "Between dates", in the formatting pane. And I need to be able to select any random date range.
@EVEAdmin , because that is text column, And that is limitation as of now.
Please log an idea or vote https://ideas.powerbi.com/ideas/
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |