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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!