Clicking on a value in table chart should show other values in another table chart except that value

[pinkukumar]

I have a table chart in which values are listed below as:

Country	Sales
US	200
UK	500
IND	700

My requirement is that - If we clicked on US , UK and IND values should show in another table chart. If I clicked on UK, US and IND should show in another table chart. If I clicked on IND, US and UK values should show in another table chart.

Can someone please tell

[V-lianl-msft · Accepted solution]

Hi @pinkukumar ,

First copy the table, then create a similar measure and put it into the visual level filter

Measure = IF(MAX('Table 2'[Country]) in VALUES('Table'[Country]),1,0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pinkukumar]

Thankyou Liang for the solution😊

[amitchandak]

@pinkukumar , option1 -You can drill through or use tooltip report.

Option 2 - Create a color measure and create table and card visual , card visual should cover the second table. USe color measure to show and hide table

The background color of card measure using conditional formatting -> field value option

Use this measure =  if(isfiltered(Table[Country]), "#FFFFFF00", "#FFFFFF")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4