cancel
Showing results for 
Search instead for 
Did you mean: 
0

Filters from visuals don't reach slicers

Short summary

I have two visuals:

  1. Bar chart
  2. Slicer

When I click an item in my bar chart, it does not filter the slicer, despite the visual interaction set to "Filter" and having a visual-level filter in slicer.

 

Details

Here's some sample data:

GroupSlicerValue
AC1
AD2
BE3
BF4

 

The bar chart has Group on axis and Value as values:

image.png

 

The slicer contains Slicer column:

image.png

 

I have the Slicer Filter measure as visual-level filter:

image.png

 

Note that the bar chart is supposed to filter the slicer:

image.png

 

And yet the filters from the bar chart don't reach the slicer:

image.pngI know the filters from the bar chart don't reach the slicer because I used Performance Analyzer and copied the slicer query:

// DAX Query
EVALUATE
  TOPN(
    101,
    FILTER(
      KEEPFILTERS(
        ADDCOLUMNS(
          KEEPFILTERS(VALUES('Table'[Slicer])),
          "Slicer_Filter", 'Table'[Slicer Filter]
        )
      ),
      [Slicer_Filter] = 1
    ),
    'Table'[Slicer],
    1
  )

ORDER BY
  'Table'[Slicer]

On the other hand, if I create a slicer based on the Group column, it will filter the slicer based on the Slicer column.

What am I doing incorrectly?

Status: Delivered
Comments
Moderator

Hi @DMM

 

Based on my research, chart visual can't filter slicer visual values currently. For your requirement, please vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12462888-cross-filter-on-a-slicer

 

Best Regards,
Qiuyun YU 

Moderator
Status changed to: Delivered