help with making the scorecard visual dynamic

[Aj24]

Hi Friends! 

just wondering if anyone knew how to make the scorecard visuals (in gray) when you click on it to make the table content at the bottom filter? e.g i want to see the 8473 number filter in the table to see who are those people in that category? 

Otherwise does anyone know a good visualisation i could add in that would achieve the same thing?

I don't want to use drill down as I will have 4 scorecards so its not really the idea situation.

scorecard visual

this is the link to the data: https://drive.google.com/file/d/1_65DTdtMzU7U9RzyfNF1r0ze_8MDp69B/view

thanks in advance for all help/advice!!

[MFelix · Accepted solution]

Hi @Aj24 ,

Cards visualizations don't have filtering capabilites on interactions with other visualizations in this case you need to create another visualization to place on top of the card then you need to do some changes:

• Create the measure:

Colour = "#00000000"

• Create a table visualization and place the marital status has a count
• Conditional format the colour and background with the previous measures
• Increase the size of the text to the maximum
• Only question is the table headers that you need to use the same colour has your background of the car but is easy using the colour selector.

Check result attach.