Forum Discussion

Koritala's avatar
Koritala
Post Patron
1 year ago
Solved

User defined Custom Periods Slicer

Hi, I have a requirement of filtering the tabular data visual default for Month to date. Also, when user select custom, it should show the date range slicer for seleting the start and end dates. In...
Need Help
alish_b's avatar
alish_b
Super User
1 year ago

Hi Koritala ,

 

Conditionally hiding report elements on slicer selection is not supported in Power BI. You will need to use Bookmarks to implement this. So basically, you will need two bookmarks:

1. MTD Bookmark: This will have a relative date filter in the filter pane set to Last 1 Month and will have the DateRange Slicer hidden.

2. Custom Date Filter Bookmark: This will have the relative date filter in the Filters pane cleared and will have the visibility of DateRange Slicer turned on.

Then map these bookmarks to respective buttons.

 


Hope it helps!