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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Resident Rockstar
Resident Rockstar

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors