Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 "Customers":
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.
Dear @v-kongfanf-msft
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |