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 am facing with a problem that filter has inactive values in options. Here is filter pane:
It shows just one value instead three as expected.
seems two last options are inactive shows 0 instead 1.
Table is here:
Hi @Analitika
Check other visuals on the same page. If there is some filter applied to other visuals or if a slicer visual has selected some options, remove those filters/selections and check the behavior of this visual's filter pane again. Also, under View tab, activate Selection and Sync slicers panes, check if there is any hidden slicer. If so, unhide them and remove selected options on them.
If some filters have been applied to other visuals and these visuals will affect the visual you hope to filter, they will affect the options on this visual.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
@Analitika
Could you please take a snapshot of the whole report and share it here? to show All visuals, tables, filters and data
I can't because data is confidential, sensitive. I can share just table and visual.
So data defined here:
Filter pane:
Pasirinkimas 2 in data preview:
So seems that some option in filter are not enabled, see 0 instead of 1.
Seems page level
Seems some options of filter are inactive. I see 0 near options.
@Analitika , Is there any page level or report level filter on the page?
My filter not works some options are disabled.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |