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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jcastr02
Post Prodigy
Post Prodigy

Card Visual not filtering

Hello.  I have a few card visuals that are of a measure (just count rows) and tehn some applied filters based on criteria.  The table on left side of screen does not filter when clicking on the card visuals.  Any ideas?Snip it Enlarged.png

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

Yes, that's what I'm saying, it doesn't work like that.  You are expecting the table visual to show you a filtered view (by the way, it's the funnel icon on the table you need to check) when you click on the card but the card is showing a measure value (a scalar value which is evaluated by filters/slicers)  .  The table doesn't respond to a scalar value.

--

If it was a data point in a graph/chart that was clicked, the table would respond because it can pass a dimension from one of the axes.  (and that would alter the table by adding another filter to the evaluation of any measure) 

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

Yes, that's what I'm saying, it doesn't work like that.  You are expecting the table visual to show you a filtered view (by the way, it's the funnel icon on the table you need to check) when you click on the card but the card is showing a measure value (a scalar value which is evaluated by filters/slicers)  .  The table doesn't respond to a scalar value.

--

If it was a data point in a graph/chart that was clicked, the table would respond because it can pass a dimension from one of the axes.  (and that would alter the table by adding another filter to the evaluation of any measure) 

jcastr02
Post Prodigy
Post Prodigy

Screenshot 2021-10-22 104208.png@HotChilliScreenshot 2021-10-22 104208.png

Both the card visual and table are pulling from the same table, but when I click on the card visual, the three that are Overdue do not show up on table.  

HotChilli
Super User
Super User

The visual will react depending on the model and filtering direction when a data point in certain other visuals is selected.  However, you are clicking on a card with a measure, so the filtering may not be doing what you think it should.   

In general, if you want to see how a visual is being filtered, hover or click on the funnel icon on a visual.  You will see what is affecting it.  

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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