Filtering by a card

[maurcoll]

Good Morning

I have a number of cards which are using a measure and a number of filters added using the filter pane.

I need to be able to filter a table of data based on the card visual selected.

How do i do this please.

I believe i need to add a shape over the card and use a bookmark this is what i am struggling to do.

[maurcoll]

Hi

In the end to achieve this i filtered the table to match the card and created a bookmark. I then assigned the bookmark to a button which i formatted to no fill etc. so you couldnt see it. I then put this over the card that i wanted to use to filter the table this worked.

[Idrissshatila]

Hello @maurcoll ,

you can filter by a measure, it should be a column so you could filter by it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Uzi2019]

Hi @maurcoll 
can share some screen shot how exactly it should work?

[maurcoll]

What i want to be able to do is click on the card and filter the table. 

The card is a measure which is count order number then in the filter pane i have added filters of less than 20 days and completed = N.

Order Number	Order Date	Country	Completed	Time Since Order	Days
1	24/05/2023	UK	Y	146	Over 100 Days
2	01/03/2023	USA	N	230	Over 200 Days
3	15/10/2023	UK	N	2	Less Than 20 Days
4	23/09/2023	Spain	Y	24	20 - 50 Days
5	04/10/2023	France	Y	13	Less Than 20 Days
6	30/09/2023	UK	N	17	Less Than 20 Days

[Idrissshatila]

@maurcoll,

yes this doesn't happen like that, you can't filter by the measure or by the card, you need a slicer or from the filter pane with a value of a column field.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡