How to click on the card visual and filter the rest of the page? (without using bookmark & pie chart

[Anonymous]

Hello All,

Greatly appreciate if anyone can share how to create a "clickable" card visual that filters all other visuals in the report? 

Without using the bookmarks or pie chart method?

Because i have slicer filters on the side for users to select, and can't use bookmarks that will overide those selection by users.

Foe example, when I click on the card, it should filter the data to only these 37 overdue projects.

[salvador_martin]

Here is a side solution I found on the web

https://stackoverflow.com/questions/59736955/power-bi-filter-table-by-clicking-on-a-card

[broniem65]

Hi, I want to do exactly the same thing.  Did you ever find a resolution to this?

[lbendlin]

Your data is already filtered to these 37 overdue projects, otherwise the card visual would not show that number.  Unless you have modified the visual interactions? 

[Anonymous]

Hello Ibendlin,

I created a measure to calculate the number of overdue projects. 

Card visuals, by default, are not clickable and I am unable to filter the other visual in the page. 

Is there a way to custom make a clickable card visual that can filter other visuals upon 'clicking'?

[lbendlin]

does that have to be a measure? Can projects become not overdue by a user modifying report filters?

[Anonymous]

The dataset does not automatically defined what is overdue and what is not.

So I have to create a measure that fulfil 2 conditions (project end date < today() & project status <> 'completed')

I just need help on how to create a clickable card visual

[lbendlin]

So I have to create a measure that fulfil 2 conditions (project end date < today() & project status <> 'completed')

If your data source is in Import mode and you have a reasonably frequent refresh schedule (for example once every workday) then you can and should use a calculated column instead - which you can then add as a page level filter or even a slicer.

[Anonymous]

Hello,  in short, I want to create a clickable card visual that filters other visuals when selected. 

(Not via slicer/bookmark/pie chart method, which can achieve that)