Filter Multi-Row Card Based on Field Values from Other Multi-Row Card Selection

[Anonymous]

Hello!

I have a set of data that has basically 4 important fields: Vendor, Vendor State, Line of Business, and Vendor Type.

Right now, I have a multi-row card showing the vendors for one of the two different Vendor Types, and I would like to add another multi-row card that shows all of the vendors of the other Vendor Type that have the same values for Vendor State and Line of Business as my selection in the first multi-row card.

Essentially, I just want to filter the 2nd card based on the values in those 2 fields when a vendor is clicked in the first card without just using a slicer or something to filter those fields instead.

Any help appreciated! Thanks!

[Anonymous]

Hi, yes

you need to change your visual interaction from cross fhighlighting to cross filtering.

Here's the thread:Cross-filtering not available from multi-row card - Microsoft Power BI Community

[Anonymous]

Hi, I looked at that thread but didn't see those options in my report settings. All that I see there is these:

[Anonymous · Accepted solution]

Hi @Anonymous ，

What's the version of your Power BI Desktop? If it is not latest one, you can download it from this link. Then you can find that option in the latest version of Power BI Desktop...

Best Regards

[amitchandak]

@Anonymous , In latest version I can see multi row car filter each other

[Anonymous]

My idea was more that clicking a Brand in the first card would pull up all other brands that are assigned to the same category in the second card. Is that currently possible?