Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Short summary
I have two visuals:
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:
Group | Slicer | Value |
A | C | 1 |
A | D | 2 |
B | E | 3 |
B | F | 4 |
The bar chart has Group on axis and Value as values:
The slicer contains Slicer column:
I have the Slicer Filter measure as visual-level filter:
Note that the bar chart is supposed to filter the slicer:
And yet the filters from the bar chart don't reach the slicer:
I 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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.