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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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