Forum Discussion

ajinkyacgaikwad's avatar
ajinkyacgaikwad
Advocate I
2 years ago

Graph Interaction and filter

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.


Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

  • ajinkyacgaikwad's avatar
    ajinkyacgaikwad
    Advocate I
    2 years ago

    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.