Graph Interaction and filter

[ajinkyacgaikwad]

I have two graphs one has country level data and another has province level data.
Country Graph has all the countries and Province graph has all the provinces from all countries.

So when I select a specific country in bar graph - related provinces get highlighted. which is basic.

BasicLooking for

I am looking for a functionality where one country is selected then the province graph should show only the related provinces in Province graph and nothing else. 
When nothing is selected in the country graph province graph should show all the provinces.

[ajinkyacgaikwad]

Hi Adam
Thank you for reverting
I am looking more for on top interaction. when a value is selected on the bar graph and not in the slicer.

[Anonymous]

Hi @ajinkyacgaikwad ,

You can create a filter table of countries and then create the following measure to apply it to the filter.

Refer to the following:

create below measure:

result_ =
VAR sel =
    SELECTEDVALUE ( slicer_[Country] )
RETURN
    IF ( sel = MAX ( 'Table'[Country] ), 1, 0 )

Best Regards,
Adamk Kong

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