Forum Discussion

Koritala's avatar
Koritala
Post Patron
10 months ago
Solved

Custom Date Range Slicer

Hi, Could you help me with the scenario below?   I want to dynamically show the 2 differnt date slicers based on slicer value slection.   In slicer, I should have 2 values, one is MTD, second on...
Need Help
  • Koritala's avatar
    Koritala
    9 months ago

    Hi Ugendar,
    Thanks for your solution. it working as expected.

Koritala's avatar
Koritala
Post Patron
10 months ago

Hi, issue not resolved. Based on selection, date slicers are not showing 

 

 

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
9 months ago

Hi Koritala ,

Thank you for your time. Since Power BI doesn’t offer conditional slicer visibility directly, I used bookmarks and the Selection pane to toggle between two slicers.
Here’s what I did.

1.Created a helper table with MTD and Custom values and used it as a slicer.

2. Slicer_Date_MTD- Set advanced filtering to show dates from the start of this month to today.

3. Slicer_Date_Custom- left unfiltered for the full date range.

4. Set up bookmarks

  • Bookmark_MTD shows the MTD slicer and hides the Custom slicer.
  • Bookmark_Custom shows the Custom slicer and hides the MTD slicer.

5. Added two buttons MTD View and Custom View linked to each bookmark, so users can switch modes easily.

FYI:

 

 

This method uses only built in Power BI features and keeps the interface simple. I’ve attached a sample PBIX file for you to review let me know if you want any changes.

 

Regards,
Yugandhar.

  • Koritala's avatar
    Koritala
    Post Patron
    9 months ago

    Hi Ugendar,
    Thanks for your solution. it working as expected.

    • Rufyda's avatar
      Rufyda
      Super User
      9 months ago

      I'm glad you found a solution! We're here in the community to support each other.

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      9 months ago

      Thank you for your response, Koritala . If possible, please mark the helpful response as the solution so it can benefit other community users more easily.