Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
tlawson004
New Member

Slicer getting stuck at unselected value

Hi there, 

 

I have a report which has a series of synced filters (one of which is visible on two pages). The filters then drive ratios calculated as Measures and in most cases these are working correctly. 

 

However, on one slicer, I am getting duplicate values from the selected slicer and the corresponding measures are being trapped by a static value I cannot trace back to a filter, nor can I find the slicer that is creating the issue. As you can see in the screenshot, the report is detecting two selected values for that filter, even though no slicer exists capping the value at 234.5. The ratio should be closer to 10%, however the denominator is getting stuck at 234.5 and it is driving me up the wall. 

 

Any possible insights would be appreciated. I have tried: 

  1. Removing and recalculating the Measure
  2. Tracing through the Selection Pane on each page, but nothing is highlighted
  3. Turning on and off the syncing of each slicer, and how they interact with other pages
  4. Deleting entire pages until the incorrect value disappears (it doesn't). 

I'm truly stumped

 

Cheers

Tom

 

Hidden slicer issue.PNG

1 ACCEPTED SOLUTION
tlawson004
New Member

FYI - I found that there were hidden slicers in the page, that were not labelled as "slicers" on the Selection Pane. Once removed the issue was corrected. 

 

 

View solution in original post

1 REPLY 1
tlawson004
New Member

FYI - I found that there were hidden slicers in the page, that were not labelled as "slicers" on the Selection Pane. Once removed the issue was corrected. 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.