Forum Discussion
URL Images Based on Slicer Selection
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.
7 Replies
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.
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
I may have an issue with my relationship(s). I have tried many combinations.
Country Flags
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
