URL Images Based on Slicer Selection

[cmcgo3]

Hello,

I cannot resolve this issue.  I have three tables, Country, State_Province, and City.  Each slicer selection represents an image.  The images for Country show image, but when filtering down to State_province, it remains on top image.  I am not sure if I need a fourth table to create relationship as well as whether tables should be many many, one to many, etc. 

 Images.pbix 

[Anonymous]

Country Flags

https://www.countries-ofthe-world.com/flags-normal/flag-of-Bulgaria.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Croatia.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Czech-Republic.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Estonia.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Hungary.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Iceland.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Kazakhstan.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Latvia.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Lithuania.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Romania.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Serbia.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Slovakia.png

https://www.countries-ofthe-world.com/flags-normal/flag-of-Slovenia.png

this is i am using as image url but still i am not able to load it idk how to do it . it's problem loading images

[PijushRoy]

Hi @cmcgo3 

I am not clear about the requirement,
I got the pbix file, can you please share a screenshot of your requirement.
Once you selected Country, the image is changing properly

Please reply

Thanks
Pijush

[cmcgo3]

I may have an issue with my relationship(s).  I have tried many combinations.

[cmcgo3]

Good Morning,

The "country" filter does work.  When you filter down to "State or Province" image should change, but does not.  The same is true for the "city" filter.  The image remains on country flag no matter what state/province or city is selected.

[PijushRoy]

Hi @cmcgo3 

Please find the attached PBIX file
Use below measure, change it if require
Use the measure in the new card visual. 
Please note, that your all measure are not in the same size.

Measure = SWITCH(
    TRUE(),
    ISFILTERED('City List'[City]),SELECTEDVALUE('City List'[url image]),
    ISFILTERED('State_Province List'[State or Province]),SELECTEDVALUE('State_Province List'[url image]),
    ISFILTERED('Country List'[Country]),SELECTEDVALUE('Country List'[URL]),
    Blank())

Image changing as per slicer

https://drive.google.com/file/d/1gmW9QJAeJmDJoiXOpCtGw2o0-eV4iI9Z/view?usp=sharing

If solved your requirement, please mark this answer as SOLUTION. appreciate your THUMBUPS 👍⬇️

Thanks 
Pijush

[cmcgo3]

 Good Afternoon Pijush,

Thank you so much!!!!!!  It works great!!!

[PijushRoy · Accepted solution]

Hi @cmcgo3 
You are welcome
If solved your requirement, please mark this answer as SOLUTION. Hit the THUMB UPS 

Thanks
Pijush