Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use a card as a filter in Power BI?

Is there a way to use a card as a slicer/filter in Power BI?

My report has two cards, "students_eligible" and "students_attended", as well as a table below them. I want to filter the table based on the cards. Meaning, if I click on the “students_eligible” card, then the table should only show the data related to “students_eligible”.

How can I accomplish this?

I’ve included an image below for context.

Attached Image

like image 802
Akash Raj Avatar asked Sep 06 '25 03:09

Akash Raj


1 Answers

There is no direct method of using a Card as filter, you can't set it as one or assign a bookmark to an action on it. What you need to is create for example a shape that sits on top of the visual, turn ofs the fill, background and boarder options, just to leave a transparent shape:

Shape options

Then create two bookmarks, one with a filter for Students Eligible, and the other for Students Attended. You may have to create a third bookmark assigned to a button or other object to return to 'No filters'.

Assign the bookmark to the shape object and ensure that it is on top of the visual. So when the use no clicks on the card, it will click on the shape, which will then filter the page based on the bookmark.

enter image description here

You can if you wish, just use the Bookmark buttons rather than click on the card object, which may be better from a user point of view

like image 81
Jon Avatar answered Sep 08 '25 00:09

Jon