March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
07-14-2020 12:20 PM
Description:
To have any custom image as a Visual while using its dependent fields in a Slicer, which can further used as a Tooltip too
Here, in this taking Indian State Emblems as an example and will show how to embed these images into a Visual (or) can be used as a Custom Tooltip.
DAX:
State Emblem =
VAR State = SELECTEDVALUE('India States'[State])
RETURN
SWITCH( TRUE(),
State = "Andhra Pradesh", "https://upload.wikimedia.org/wikipedia/commons/thumb/9/9e/Andhraseal.png/150px-Andhraseal.png",
State = "Arunachal Pradesh", "https://upload.wikimedia.org/wikipedia/commons/thumb/c/c2/..Arunachal_Pradesh_Flag%28INDIA%29.png/15...",
State = "Assam", "https://upload.wikimedia.org/wikipedia/commons/thumb/e/e8/Seal_of_Assam.png/150px-Seal_of_Assam.png",
State = "Bihar", "https://upload.wikimedia.org/wikipedia/commons/thumb/e/e9/Seal_of_Bihar.svg/150px-Seal_of_Bihar.svg....",
State = "Chhattisgarh", "https://upload.wikimedia.org/wikipedia/commons/thumb/5/5b/..Chhattisgarh_Flag%28INDIA%29.png/150px-....",
State = "Goa", "https://upload.wikimedia.org/wikipedia/commons/thumb/d/d7/Goa_government_banner.png/150px-Goa_govern...",
State = "Gujarat","https://upload.wikimedia.org/wikipedia/commons/thumb/a/a6/Government_Of_Gujarat_Seal_In_All_Language...",
State = "Haryana","https://upload.wikimedia.org/wikipedia/commons/thumb/8/87/..Haryana_Flag%28INDIA%29.png/150px-..Hary...",
State = "Himachal Pradesh","https://upload.wikimedia.org/wikipedia/commons/thumb/7/76/Himachal_Pradesh_Flag%2C_India.png/150px-H...",
State = "JharKhand","https://upload.wikimedia.org/wikipedia/commons/thumb/a/a4/..Jharkhand_Flag%28INDIA%29.png/150px-..Jh...",
State = "Karnataka","https://upload.wikimedia.org/wikipedia/commons/thumb/a/aa/Seal_of_Karnataka.svg/150px-Seal_of_Karnat...",
State = "Kerala","https://upload.wikimedia.org/wikipedia/commons/thumb/5/55/..Kerala_Flag%28INDIA%29.png/150px-..Keral...",
State = "Madhya Pradesh","https://upload.wikimedia.org/wikipedia/commons/thumb/b/be/..Madhya_Pradesh_Flag%28INDIA%29.png/150px...",
State = "Maharashtra","https://upload.wikimedia.org/wikipedia/commons/thumb/2/26/Seal_of_Maharashtra.png/150px-Seal_of_Maha...",
State = "Manipur","https://upload.wikimedia.org/wikipedia/commons/thumb/8/8b/..Manipur_Flag%28INDIA%29.png/150px-..Mani...",
State = "Meghalaya","https://upload.wikimedia.org/wikipedia/commons/thumb/5/59/Seal_of_Meghalaya.svg/150px-Seal_of_Meghal...",
State = "Mizoram","https://upload.wikimedia.org/wikipedia/commons/thumb/5/56/Seal_of_Mizoram.svg/150px-Seal_of_Mizoram....",
State = "Nagaland","https://upload.wikimedia.org/wikipedia/commons/thumb/0/00/..Nagaland_Flag%28INDIA%29.png/150px-..Nag...",
State = "Odisha","https://upload.wikimedia.org/wikipedia/commons/thumb/f/fe/Seal_of_Odisha.png/150px-Seal_of_Odisha.pn...",
State = "Punjab","https://upload.wikimedia.org/wikipedia/commons/thumb/5/54/Emblem-Punjab-Protocol-Manual-page98-appen...",
State = "Rajasthan","https://upload.wikimedia.org/wikipedia/commons/thumb/1/1e/Emblem_Rajasthan.png/150px-Emblem_Rajastha...",
State = "Sikkim","https://upload.wikimedia.org/wikipedia/commons/thumb/c/c0/Seal_of_Sikkim.svg/150px-Seal_of_Sikkim.sv...",
State = "Tamil Nadu","https://upload.wikimedia.org/wikipedia/commons/thumb/8/81/TamilNadu_Logo.svg/150px-TamilNadu_Logo.sv...",
State = "Telangana", "https://upload.wikimedia.org/wikipedia/commons/thumb/f/f7/Government_of_Telangana_Logo.png/150px-Gov...",
State = "Tripura","https://upload.wikimedia.org/wikipedia/commons/thumb/7/73/Seal_of_Tripura.svg/150px-Seal_of_Tripura....",
State = "Uttar Pradesh","https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/Seal_of_Uttar_Pradesh.png/150px-Seal_of_Ut...",
State = "Uttarakhand","https://upload.wikimedia.org/wikipedia/commons/thumb/1/17/..Uttarakhand_Flag%28INDIA%29.png/150px-.....",
State = "West Bengal","https://upload.wikimedia.org/wikipedia/commons/thumb/d/d5/Emblem_of_West_Bengal.svg/150px-Emblem_of_...",
State = "Andaman and Nicobar Islands","https://upload.wikimedia.org/wikipedia/en/thumb/c/cd/Seal_of_Andaman_and_Nicobar_Islands.png/150px-S...",
State = "Chandigarh","https://upload.wikimedia.org/wikipedia/commons/thumb/e/ed/..Chandigarh_Flag%28INDIA%29.png/150px-..C...",
State = "Dadra and Nagar Haveli and Daman and Diu","https://upload.wikimedia.org/wikipedia/commons/thumb/d/d6/Dadra_and_Nagar_Haveli_and_Daman_and_Diu_e...",
State = "Delhi","https://upload.wikimedia.org/wikipedia/commons/thumb/2/24/Seal_of_the_National_Capital_Territory_of_...",
State = "Jammu and Kashmir","https://upload.wikimedia.org/wikipedia/commons/thumb/7/78/Government_of_Jammu_and_Kashmir.png/150px-...",
State = "Ladakh","https://upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Ladakh_Government_Banner.png/150px-Ladakh_...",
State = "Lakshadweep","https://upload.wikimedia.org/wikipedia/en/thumb/8/8a/Seal_of_Lakshadweep.png/150px-Seal_of_Lakshadwe...",
State = "Puducherry","https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Seal_of_Puducherry.svg/150px-Seal_of_Puduc...",
BLANK()
)
Please don’t hesitate to ask or comment on the measure. I’ll be gladly elaborate and help with anything regarding this.