Forum Discussion
Need help with filting
- 5 years ago
Anonymous ,
Countrows(Tables) - should all records with filter on table and related tables
calculate(Countrows(Tables), all(Table) ) - should all records without filter on table and related tables
Click on the card is not a action. You can use the bookmark button for that
https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Hi, Anonymous
Card visuals can respond to interaction originated from other visuals and change values on them, but they aren't currently the origin of interaction. I think you can use a Slicer to help you filter the records in the table related with Card Visual or considering Card drill through in Power BI.
1 Create a table with all records
2 Create a Slicer
3 Create a Card visual
4 When clicking item in Slicer, value on the Card and records in the table will change together
Best Regards,
Caiyun Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.