Single date slicer which is filterable

[adityah]

Hi Guys,

Posting this since I did not find anything exactly similar. Is it possible to filter a report with a toggle/if condition using a single date slicer.

Like if I have two dates in a single table, 'policy_created_ts' and 'payment_ts'. I want a toggle button and a single date slicer that responds to that toggle button. Is this possible in power BI and are there any workarounds?

[Anonymous · Accepted solution]

Hi @adityah ，

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We need to create two slicers for these two date columns. Hide the [payment_ts] slicer and create a bookmark policy, then hide the [policy_created_ts] slicer and create a bookmark pay. then find Insert->Buttons->Navigator->Bookmark Navigator in the menu bar.

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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