Forum Discussion

Post Patron

6 years ago

Solved

Relative Date Slicer AND Date Range

Hello Community - I am trying to figure out a way to be able to use two types of date slicers in the same report. So I have a report that I use the Relative Date slicing on most of the time,...

Need Help

Show and Tell

Tips and Tricks

v-yuta-msft
6 years ago
ryan_b_fiting ,

Using bookmark is correct, you only need to disable the sync slicers between different pages. For more details, please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ryan_b_fiting

Post Patron

6 years ago

amitchandakthanks for the reply, but this is not what I am looking to accomplish. I already have a date table that is joined to my fact tables. I have created all the measures that I need.

All I am looking for is the ability to change my date ranges from a specific range (4/1/2020 - 4/19/2020) to a relative date range (in the last 1 month, last 1 week etc).

I will look most of the time at the last N days/weeks/month with the relative slicer, howeer I want to have the ability to be able to look at a specific date range for certain reasons.

I am looking for the ability to toggle between 2 different slicers on the same date (from the date dimension table) but when switching from one ot the other, I need all date filters to be cleared.

Does that make sense?

Thanks

v-yuta-msft