Forum Discussion

Advocate I

7 years ago

'Select All' doesn't work when filtering a slicer.

The new slicer filtering is great but it appears to be broken when using the 'select all' functionality. Is this just me?

General Comment

Super User

6 years ago

Hi D_PBI ,

Apologies for tagging you by mistake.

Kashinoda Can you confirm that you are using the same column in Visual level filter, your slicer and your chart?

As i am not able to replicate the same issue as you are facing. For me it works.

Thanks,

Pragati

Advocate I

6 years ago

Its still the case, latest version of Power BI Desktop with Excel as source. (Happens in SQL or Analysis Services too)

Using 'Select All':

Manually selecting 'Bob' and 'Aaron'

Relationship:

Pragati11
Super User
6 years ago
Hi Kashinoda ,

Can you make your relationship bi-directional and see if this works?

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,
Pragati
- Kashinoda
  Advocate I
  6 years ago
  Pragati11
  
  A bi-directional relationship doesn't solve the issue, I wouldn't expect it to either. I uploaded the PBIX, Try yourself:
  https://drive.google.com/open?id=10QwYrgDYd4pGz8ZIGTUL92KRoh02Tyul
  - Pragati11
    Super User
    6 years ago
    Hi Kashinoda ,
    
    I think you are not trying things the way they work:
    
    1. Visual level filter of EMPLOYEE on your bar chart:
    When you select anything on EMPLOYEE, the bar chart will get filtered as it is a visual level filter on your chart. This will not filter the slicer present on the report.
    
    2. Trying to filter the chart using the Slicer present on the report:
    This will affect the chart and filters it based on the selection in the slicer.
    
    Now the above screenshots are from the pbix file that you shared.
    It looks perfectly fine to me.
    
    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
    
    Thanks,
    Pragati

Related content