Slicer selection must change the selection of other slicer

[julsr]

Hello everyone,

I have a table called "dates" which has "date" and "sales_id_year" fields. I use the "date" field from "dates" in one slicer and the "sales_id_year" in another slicer. However, what I need is that when I change the date in the date slicer, the sales_id_year slicer updates to only show and active the options corresponding to that year. How can I accomplish this? In the image, I need that when 2025 is selected, 2024 doesn't appear visible (this happens when 2024 was previously selected and then changed to 2025, the selection remains).

Here is a sample powerBI file. https://drive.google.com/file/d/1rlnBCBRJOfaDM-4svD9cd6jA9zpGpEWg/view?usp=sharing

Thanks!

[danextian]

Hi @julsr 

@PijushRoy  describe exactly how a slicer works. If you want a slicer to not be affected by other slicers you can either remove the interaction between them or put them to their own separate dimension tables - so you have a separate table for just the dates and another one for for just the sales_id_year and then relate both to your fact table.

[julsr]

Ok, thank you! Or, do you have an idea if possible to set up a formula that if the date does not match from the date filter with the other slicee, then show a Blank field in the sales_id_year slicer? Ok, thank you! Or, do you have any idea if it's possible to set up a formula that would show a blank field in the sales_id_year slicer if the date from the date filter doesn't match with the other slicer?

[v-aatheeque]

Hi @julsr ,

It is possible to configure slicers in Power BI to show blank values based on the selection of other slicers. You can achieve this by using DAX measures to control the visibility of the sales_id_year slicer based on the date filter's selection.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[v-aatheeque]

Hi @julsr ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @julsr ,

I wanted to follow up regarding your inquiry about the slicer selection functionality in Power BI. Specifically, you mentioned the need for one slicer selection to influence the selection of another slicer.

If you have had a chance to explore the suggested solutions or if you require further assistance, please let me know. I am here to help and ensure that your issue is resolved.

Thank you for your attention, and I look forward to your response.

[julsr · Accepted solution]

Hello! Sorry for the delay.

I was able to solve this by creating a relationship of one way between the two calculated tables and the main table, and then modifying the visual level filters of the slicer based on the selection of the year to ensure that the year of the range filter is within the same year as the dropdown values. Thanks everyone for your help!

[PijushRoy]

Hi @julsr 
It is working perfectly but it will not work if you already selected FY24. In your case, you already selected FY24, then you are changing the slider, first you need to clear the selection.
If you already selected any thing, then power bi will not cancel this and make another selection. This is how the slicer build.
Clear the selection and then check
Implement Clear All Slicer button for more user friendly design https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=p...

[julsr]

Thanks for your reply! Forgot to mention that the slicer for the sales_id_year must have the single selection feature active and this way it doesn't work as you mentioned.