cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

"Dynamically" predetermined slicer

Hello,

I have a slicer to filter on the exact date to show this dates revenue. What i want to do is set the slicer dynamically to todays date (if i open today, slicer is dynamically set to "04.06.2020", if i open tomorrow it is set to "05.06.2020" and so on) with the option for the user to change to filter to another Date.

 

Is this possible?

 

Regards,

Dennis

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: "Dynamically" predetermined slicer

@dennis_tegut , Try relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or Have this column in your date table and use that as slicer of page-level filter

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: "Dynamically" predetermined slicer

@dennis_tegut , Try relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or Have this column in your date table and use that as slicer of page-level filter

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Helper I
Helper I

Re: "Dynamically" predetermined slicer

@amitchandak 

Thank you very much! The calculated column is genius and exactly what i wanted!

 

Regards,

Dennis

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors