cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tt211595
Frequent Visitor

Crossfiltering with field parameter

Hello! I have a couple visuals where I'm using a field parameter to switch between counts and percentages. I'm able to use the cross-highlight feature, but I'm unable to cross-filter (probably because a lack of field relationships). Is it possible to cross-filter with field parameters?

 

As an example, say my data consists of 6 vehicles, with columns for vehicle color, type, fueltype, and an ID column.

tt211595_0-1685291573989.png

 

I'd like to visualize color and vehicle type with a user option to show counts or percentages.

tt211595_2-1685291663209.png

 

The x-axes of these two visuals are based on the following parameter with the radio button slicer on "Count vs Percent":

tt211595_3-1685291726985.png

 

I'm using filters on the two visuals to show vehicle color or vehicle type (example below in screenshot):

tt211595_4-1685291800696.png

 

Cross-highlighting works correctly, but when I try to cross-filter, all the bars from the other visual disappear.

tt211595_5-1685291873790.png


Is cross-filtering possible in this scenario? Thanks in advance!

2 REPLIES 2
tt211595
Frequent Visitor

Thanks for your response, @amitchandak. I've included a pbix file at the link below. I still haven't been able to get cross-filtering to work (but cross-highlighting does work). Thanks in advance.

 

https://drive.google.com/file/d/1JRzveUHofMOSg4M3VnivzePfSwJjyKCn/view?usp=sharing

amitchandak
Super User
Super User

@tt211595 , I tried on my file. interaction is working properly in my case

Both Using parameter

amitchandak_0-1685327590461.png

 

left on is on parameter

amitchandak_1-1685327636151.png

 

right filtering left

amitchandak_2-1685327651509.png

 

Check measures

 

If this does not help
Can you share a sample pbix after removing sensitive data.

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors