Forum Discussion
Single date slicer which is filterable
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?
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.
1 Reply
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.