Forum Discussion

T_BZH's avatar
T_BZH
Frequent Visitor
2 years ago

Erratic filter / Slicer behavior

Hello, I have a very erratic behavior on one of my Power BI dashboard and I can't figure it out. I use a very simple measure where I calculate the number of rows in a table removing filters on "C...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi T_BZH ,

 

Viewing Slicer Synchronization Settings: Ensures that the Client slicer is not inadvertently synchronized with other slicers.
You can manage this setting by going to the View menu, selecting Synchronize Slicers, and then reviewing each slicer's settings to ensure they are configured as expected.

Slicers in Power BI - Power BI | Microsoft Learn

 

If the problem persists, please provide relevant screenshot information and describe it.

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

T_BZH's avatar
T_BZH
Frequent Visitor
2 years ago

Dear Anonymous 

 

Thank you for you prompt reply.

Slicers do sync from home page to problematic tab, it is as designed and expected, the thing is that behavior becomes problematic only when I move some slicers like "Date", "Country".
For example :

 

Formula :  VAR _test = CALCULATE(COUNTROWS('Data extract'),ALL('Data extract'[Customer]))

 

6 lines in my table :

1 - No action (No filters)

VAR_Test returns 6

2 - Customer A is selected with no other filter on "Home" tab

VAR_Test returns 6 (Works!)

3 - Country slicer selects "CA" on "Home" Tab (No other filter)

VAR_Test returns 2

4 - As Country Slicer is still selecting "CA" I select Customer "A"

VAR_Test returns 1 <- This is what I mean, as I remove filters on Country it should still count 2

 

Hope this clarify my situation, I did not provide screenshots as Data is a way more complex.

 

Thanks again for you help Community!