Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Analitika
Post Prodigy
Post Prodigy

Filter pane not works well

Hello,

 

I am facing with a problem that filter has inactive values in options. Here is filter pane:

Analitika_0-1629445724078.png

It shows just one value instead three as expected.

Analitika_1-1629445767831.png

seems two last options are inactive shows 0 instead 1.

Table is here:

Analitika_2-1629445821353.png

 

6 REPLIES 6
v-jingzhang
Community Support
Community Support

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. 

082402.jpg

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.

VahidDM
Super User
Super User

@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:

Analitika_0-1629446740086.png

Filter pane:

Analitika_1-1629446768013.png

Pasirinkimas 2 in data preview:

Analitika_2-1629446813395.png

So seems that some option in filter are not enabled, see 0 instead of 1.

Analitika
Post Prodigy
Post Prodigy

Seems page level 

Analitika_0-1629446340238.pngAnalitika_1-1629446361138.png

Seems some options of filter are inactive. I see 0 near options.

amitchandak
Super User
Super User

@Analitika , Is there any page level or report level filter on the page?

My filter not works some options are disabled.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.