Forum Discussion
Change image dynamically through slicer hierarchy
Anonymous
That table is not enough. You will need the image URLs for cities and countries at least. You can adopt several structures. One of them in the attached file, where you can see it all at work.
You can create a measure that will yield the desired URL depending on the selection on the slicer. That can then be the input for the visual showing the images
_VisualInput = IF ( ISFILTERED ( Table1[City] ), SELECTEDVALUE ( Table1[City_Image] ), IF ( ISFILTERED ( Table1[Country] ), SELECTEDVALUE ( Table1[Country_Image] ) ) )Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Community ChampionAnonymous
That table is not enough. You will need the image URLs for cities and countries at least. You can adopt several structures. One of them in the attached file, where you can see it all at work.
You can create a measure that will yield the desired URL depending on the selection on the slicer. That can then be the input for the visual showing the images
_VisualInput =
IF (
ISFILTERED ( Table1[City] ),
SELECTEDVALUE ( Table1[City_Image] ),
IF ( ISFILTERED ( Table1[Country] ), SELECTEDVALUE ( Table1[Country_Image] ) )
)
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |