Forum Discussion
Controlling filters from visuals
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
4 Replies
- amitchandak
Super User
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
- Jihwan_Kim
Super User
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/ - v-kkf-msft
Community Support
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-kkf-msft
Community Support
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