Controlling filters from visuals

[CarlsBerg999]

Hi,

I have a page with 2 visuals (illustrated in the Excel below). Visual 1 is a visual where i want to select values that are shown in Visual 2. However, the visual 1 has filters coming from the filters pane and i want these to be ignored in the Visual 2. How do i ignore the filters pane selections? 

For example, in the picture below, when i click Category 3, i want Visual 3 to show all category 3 values, including blank values. 

This visual has filters applied to it on the filters pane. When

[v-kkf-msft]

Hi @CarlsBerg999 ,

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @CarlsBerg999 ,

You can try to put the Sub-Category column in the slicer, and then select the Edit interactions in the Format.

Make visual 2 not filtered by the slicer. This will get the result you want.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[Jihwan_Kim]

Hi, @CarlsBerg999 

Please correct me if I wrongly understood your question.

Visual 1 -> Instead of using Filter Pane, try to write a measure that filters out blank values + only shows subcategory5.

For instance, something like below.

measure for visual 1 = 

if ( selectedvalue (category) = category 3, calculate (yourmeasure, filters out blank values + only shows subcategory5 ), yourmeasure )

Or, please share your sample pbix file's link, then I can try to have a look into it to come up with a more accurate solution.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@CarlsBerg999 , You can stop interactions

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

or my video :https://www.youtube.com/watch?v=GIfRKzhMaR4

if you want to control with all or independent table

refer: https://www.youtube.com/watch?v=lOEW-YUrAbE