Selected slicer options remain in slicer when they should become unavailable

[zahin_maisa]

The options in my slicer on the right should match the matrix on the left (they don't affect each other).

These options depend on selections made in a slicer in the previous page. When I go back and change the selections on that slicer, the slicer updates but the already selected options don't clear. Is there a solution/workaround anyone is aware of?

[v-menakakota · Accepted solution]

Hi @zahin_maisa ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

To filter a slicer so that it only displays BuildIDs included in the Matrix (based on data from two tables  BuildList and MatchingData), follow these steps:
 Create the Match Calculated Column in MatchingData Table

Go to the MatchingDatatable and add a new calculated column:

Match =

DIVIDE(

    INT([AB001]) + INT([AB521]),

    2

)
This calculates the average of AB001 and AB521 values.
Format it as Decimal Number and set its Format to Percentage using the Modeling tab in the ribbon.

Create a Matrix Visual to Display the Values

• Add a Matrix visual to your report canvas.
• Drag the following fields:
• BuildID → Rows
• AB001, AB521, and Match →
  
  Create the IsInMatrix Calculated Column in BuildList Table

In the  BuildList table, add the following calculated column:

IsInMatrix =

IF (

    'BuildList'[BuildID] IN VALUES('MatchingData'[BuildID]),

 1,

   0

)

Filter the Slicer Using IsInMatrix

To make the slicer show only those BuildIDs that appear in the matrix:

1. Click to select your Slicer visual.
2. Open the Filters pane (right side, below Fields).
3. Drag IsInMatrix (from the  BuildListtable) into the "Filters on this visual" section.
4. Set the filter to show only values where IsInMatrix is 1.
   
   Additionally, I have included the PBIX file that I created using the sample data. Kindly review it and confirm whether it aligns with your expectations.
   
   If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[zahin_maisa]

Match = no. of selected sales options in given arrangement. The user may select any no. of options: 

[v-menakakota]

Hi @zahin_maisa  ,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues. 

Thank you for your understanding and assistance. 

Best Regards, 
Menaka.
Community Support Team  

[zahin_maisa]

I have received no solution: 

[v-menakakota]

Hi @zahin_maisa  ,
We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-menakakota]

Hi @zahin_maisa ,

Thanks for sharing the screenshot. This is a known limitation where the child slicer keeps its selection even after the parent slicer changes. The product team is aware and working on a fix. For now, the only workaround is to manually clear the child slicer. We appreciate your patience

[v-menakakota]

Hi @zahin_maisa ,

You’re absolutely right ,slicers can keep old selections even if those values no longer appear in the updated matrix. This is a known behavior in Power BI. Unfortunately, slicers don’t automatically clear or update their selections when the underlying data changes due to filters on another page.

We’ve applied standard techniques to manage this (like filtering with IsInMatrix=1), but this limitation still remains.

To get more insights or potential workarounds, I’d recommend raising a support ticket with Microsoft Power BI Support:

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

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

Thank you.

[zahin_maisa]

Hi, 

A little more context:

1. Build List (matrix rows), and Sales Options (matrix columns) are fields in the same data table

2. 'Match' is the renamed col total for the measure '% Match': 

% Match = 
 IF(
    HASONEFILTER(REP_ARC_TO_SOS_DETAIL[_SalesOption]),
    FORMAT(COUNT(REP_ARC_TO_SOS_DETAIL[ContainsCode]), "0.00%"),
    FORMAT(COUNT(REP_ARC_TO_SOS_DETAIL[_SalesOption])/[SelectedSalesOptions],"0.00%")
 )

This measure is displays 100% in matrix cells (hidden by conditional formatting)

[v-menakakota]

Hi @jabrillo ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.