Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The chicletSlicer.1.3.0 is not filtering correctly once you deploy it. It appears to work ok in the desktop version. We are using it to "filter" on year and month (Year Slicer and Month Slicer). It seems to have stopped working on older versions as well. We have had to replace all of the chiclet slicers with the (ugly) default one provided to get things working again.
From what we can tell... it seems to clear out or loose what is selected. So then the report opens up.. it shows for all years and months.. then does another recalc to start applying them but doesn't get the selections/filters; re-applied correctly even though the correct year and month are highlighted. Sometimes we get the year selected, sometimes we get the month selected, sometimes we get both.. and other times nothing gets selected (filtered). If you refresh the report then everything seems to correct itself.
To debug, we added this this on our report so we can see if the year gets selected correctly or not.. similar code for the month.
-Expected Start Term Year- = IF (COUNTROWS(ALLSELECTED(View_ExpectedStartDate[Expected Start Year No])) > 1, "Year (Multiple)", FIRSTNONBLANK(View_ExpectedStartDate[Expected Start Year Name], ALLSELECTED(View_ExpectedStartDate[Expected Start Year Name])))
Is there any control order sequence on how things get applied?
Report Level
Page Level
Slicers?
Visual Filters?
Hi @synergised,
>>Is there any control order sequence on how things get applied?
There filters works at same time(use"and" logic), they don't contains the order sequence.
For your issue of new version chiclet slicer, I'd like to recommend you contact to power bi custom visual team to confirm these new features and updates.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
64 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |