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
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?
Solved! Go to Solution.
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)
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)
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
112 | |
105 | |
94 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |