Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.