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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Analitika
Post Prodigy
Post Prodigy

Set true in filter pane

Hello,

 

I would like to ask how to enable true option in filter pane.  Some values are 0 instead 1.

Analitika_0-1629440735869.png

 

1 ACCEPTED SOLUTION

Hi @Analitika ,

 

I try to recreate your scene. This is due to conflicts between slicers and filters.

Vlianlmsft_0-1629782638124.png

If you select the option in the filter first then use the slicer, the items filtered by the slicer will be displayed as 1, and the items not within the filter range of the slicer will be displayed as 0.

Slicers take precedence over visual level filters, less than page level filters and report level filters.

 

 

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

View solution in original post

10 REPLIES 10
VahidDM
Super User
Super User

@Analitika 

 

Can you please take a snapshot from table and all filters of that table and share that here?

Analitika_0-1629444160681.pngAnalitika_1-1629444190093.png

In data view and transform data view.

here is filter pane

Analitika_2-1629444242820.png

 

Hi @Analitika ,

 

I try to recreate your scene. This is due to conflicts between slicers and filters.

Vlianlmsft_0-1629782638124.png

If you select the option in the filter first then use the slicer, the items filtered by the slicer will be displayed as 1, and the items not within the filter range of the slicer will be displayed as 0.

Slicers take precedence over visual level filters, less than page level filters and report level filters.

 

 

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

Thejeswar
Super User
Super User

Hi @Analitika ,

That comes automatically when that column is added to the visual.

 

Would you mind chcking if there is any page level filter or report level filter that is restricting the data in the visual

Actually I have table Parinkimas 2 which is added to filter but some values are 0 instead 1. Seems not activated.

Here how looks my Parinkimas 2 in data transform.

Analitika_0-1629442361312.png

In filter pane just EBITDA is activated.

Analitika_1-1629442410028.png

 

I tried with a similar data set.

 

I can see the Basic Filtering automatically brings in those values

Find below the Screengrab

Thejeswar_1-1629443539238.png

 

Visual Level filter, Page Level Filter and Report Level filters respectively can be seen in the FILTERS Pane as can be seen below screenshot

Thejeswar_2-1629443646204.png

 

My filter pane looks like this.

Analitika_0-1629444274839.pngAnalitika_1-1629444304523.png

 

 

Analitika_2-1629444385276.png

 

I don't see how enable filter options.

My filter visual looks like this 

Analitika_0-1629444683938.png

 

Analitika
Post Prodigy
Post Prodigy

How?

Analitika
Post Prodigy
Post Prodigy

Like this 

Analitika_0-1629441740212.png

 

Analitika
Post Prodigy
Post Prodigy

How make that other will be 1 instead 0?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors