Forum Discussion
Cross Filtering with Top N
I have one bar chart that gives me the Top N (15) Categories by a particular measure.
I want to highlight within another chart based on what a users selects in the bar chart.
It seems though that if i use top N in the first chart, it wont filter the 2nd chart. I get a warning about cross filtering:
Cross highlighting has been disabled for this visual.
Cross highlighting has been disabled for this visual. The source of the highlighting has a Top N filter applied on a field that isn't used as a group in this visual (for example, an axis or legend). If you need the cross highlighting, you can remove the filter.
Is there a way around this using Top N or do i just have to revert to not using Top N, or using a home grown Top N Solution?
4 Replies
I'm seeing the same thing, which is a bit disappointing. I recall when I was using home-grown TopN solutions (based on RANKX) that I didn't see these issues.
I plan to try to see what I can do to resolve this in the coming week, but it may mean for me to go back to the old TopN approaches.
Sounds a bit strange. Do you have bidirectional filtering turned on in your data model (on the relationships)? If so, try turning them off. Also post your measures for top n and the other visual
Hi,
Multi diretion filtering is not configured on the relationships (filter direction is not set to "To Both Tables").
I wasnt using any Top N Measures, I was using the built in Top N filter in powerBI.
I was looking forward to this feature as it would mean i wouldnt have to roll my own TopN solution. this was the first time i was trying it out.
