The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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:
I'm truly stumped
Cheers
Tom
Solved! Go to Solution.
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.
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.