cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrOogaBooga
New Member

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

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!

 

 

1 ACCEPTED SOLUTION

Hi @MrOogaBooga ,

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...

yingyinr_2-1650963261263.png

yingyinr_1-1650963215767.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Noorani
Helper II
Helper II

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

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

MrOogaBooga_0-1650656363801.png

 

Hi @MrOogaBooga ,

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...

yingyinr_2-1650963261263.png

yingyinr_1-1650963215767.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

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

 

amitchandak_0-1650648049852.png

 

amitchandak_1-1650648066813.png

 

 

 



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

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?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors