Power BI - Filter table by clicking on a card

Question

In Power BI, I have a table that contains rows associated with one of five possible categories. I've created three cards that shows the count of rows for category 1, category 2, and the remaining three possible categories.

I would like to filter the table based on the card that I click on. How can I filter visuals by clicking on a card?

Answer 1

You can do this by using bookmarks. The following link walks you through how you can create a bookmark and use it:

https://learn.microsoft.com/en-us/power-bi/desktop-bookmarks

You should place buttons over each of the cards (Make sure you turn off the background and borders to make sure they look aesthetically right). Then all you have to do is assign bookmarks to each of the buttons to filter the corresponding data. Hope this helps.