Forum Discussion
EVEAdmin
Post Patron
3 years agoAutomatic Update Date Slicer to Today
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, wh...
EVEAdmin
Post Patron
3 years agoamitchandak 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.
amitchandak
Super User
3 years agoEVEAdmin , because that is text column, And that is limitation as of now.
Please log an idea or vote https://ideas.powerbi.com/ideas/