Forum Discussion

Helper II

6 years ago

Relevant Data in Filters

I would like to limit the options in filters as values are selected in other filters. This was easy in Tableau, I just click "Only Relevant Values" in the filter settings. Is there a way to do this...

Need Help

Tutorial Requests

Anonymous

Not applicable

6 years ago

Hi ghutchins ,

Not very clear, but I understand you want to filter values in another filter based on the selection.

Se this video.

https://www.youtube.com/watch?v=cyOquvfhzNM

One Slicer to filter other slicers based on Items that has value only in Power BI without BI Directi

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

ghutchins

Helper II

6 years ago

I am not using Slicers... I am only using the Filters..

Pragati11
Super User
6 years ago
Hi ghutchins ,

Can you share some screesnhots around what you are using and trying to achieve?

Always add details to your query for others to understand in a better way.

Thanks,

Pragati
- ghutchins
  Helper II
  6 years ago
  
  In the Filters Pane I have the following... In the first image nothing is selected for 'AreaName' so no effect on 'Level Name' is expected.
  
  In the second image I have selected 3 choices for 'AreaName', I see that 'LevelName' was not filtered to only include those options that are associated with the 'AreaName'
  
  Pragati11, Anonymous , AllisonKennedy
  - Pragati11
    Super User
    6 years ago
    Hi ghutchins ,
    
    I tried the similar scenario at my end and it seems to work. Consider following example:
    
    Now if I select anything in my 1st filter, 2nd filter reflects the chnage:
    
    Both of my above filters are coming from same table.
    
    At your end, are they in same table?
    
    If they are not in same table, then are they coming from related tables?
    
    Thanks,
    
    Pragati