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.

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

Hi Koritala ,
Could you please let us know whether your issue has been resolved or if you are still encountering any difficulties? Your feedback is important to the community and may assist others with similar concerns.

Thank You.

  • 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.