Forum Discussion
Filtering by a card
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.
5 Replies
- maurcollHelper IV
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 - IdrissshatilaSuper User
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 đź’ˇ
- IdrissshatilaSuper User
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 đź’ˇ - maurcollHelper IV
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.