cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
joannali
Regular Visitor

How to make filters show all values when another filter is in use?

I have a report in which the regions are based on the countries. For eample:

North Europe

DK
North EuropeSE
North EuropeFI
South EuropeIT
South EuropeES

 

I have created a region filter, and a country filter, so that when North Europe is selected, only DK, SE and FI shows in the country filter.

Is it possible to make the country filter show all countries (in this case show IT and ES, when North Europe is selected? So that users have the options to click on for example, IT, and the region filter will then select both South Europe and North Europe.

 

Thank you!

 

6 REPLIES 6
Super User I
Super User I

Re: How to make filters show all values when another filter is in use?

It all depends on your table structure, if they in the same table, that should automatically if you have 2 slicers and select the region first


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
joannali
Regular Visitor

Re: How to make filters show all values when another filter is in use?

yes, now the region slicer filters the country slicer.

 

What I want to achieve, is when a region is selected, countries which are not part of that region, still shows up in the country slicer.

Super User III
Super User III

Re: How to make filters show all values when another filter is in use?

Hi @joannali ,

 

you need to turn off the interaction between the two slicers, but be aware that if the users select different option from both the slicer they will get blank visuals, so may not be very intuitive in terms of user experience.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


joannali
Regular Visitor

Re: How to make filters show all values when another filter is in use?

So there is no way to make two filters that can filter each other both ways? I dont want to turn off the interaction between them, instead, I want them to be interactive.

 

 

Super User III
Super User III

Re: How to make filters show all values when another filter is in use?

Hi @joannali ,

 

But if you have the need to have the interaction between both when you select IT you will only get Shout Europe and not both values in the region slicer.

 

Or have we missunderstood your question?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


Super User I
Super User I

Re: How to make filters show all values when another filter is in use?

@joannali i think we missing some information here, can you show us your relationship diagram?  if they are in same table the fields, you should be able to filter one slicer and get the other to automatically adjust to the values that are related to that value.

 

If you have them in separate tables, you will need a bi directional filter that filters both ways

 

if you are expecting it to impact the actual visuals you need to change the interaction in the ribbon menu ie. format / edit interactions which will adjust your visuals

 

if you provide screenshots of your data and what you trying to do this will help us to help you.

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors