Forum Discussion

bharosha's avatar
bharosha
Icon for Helper I rankHelper I
1 year ago
Solved

slicers automatically selected based on another slicer selection

I have a table that has id, open date and close date. I need to be able to select a date on close date filter, depending upon the selection, open date slicer gets automatically selected. Is there a w...
  • bharosha's avatar
    bharosha
    1 year ago

    Thank you for your help. Both of these options do not help me with pre-selection. I found preselection slicer that I used and solve this issue. 

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
1 year ago

Hi bharosha,

As per my knowledge, Power BI doesn’t support automatic slicer syncing, but we can simulate it using below approach:

A shared DateTable
Dual relationships (active/inactive)
DAX measures with USERELATIONSHIP
Visual-level filters
This method keeps your dashboard dynamic and responsive to user selections.

I am attaching pbix file for your reference, please check it.
slicers automatically selected based on another slicer selection.pbix

 

Hope the above pbix solution may help you.

Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X