The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Community,
I have a Requirement where I need to show different Color Image based on the Status
If Late - Red, On Time - Green, Blocked - Black
I have tried a Work around by Putting 3 images one over another and using Bookmark feature hiding the other 2 depending on the button selected and it works but only if there is One set of 3 Train images (just for one Station).
I have 15 stations and If I set for one then others are disturbed.
So if there is any Function to do so or any suggestions or Work Around I highly appreciate your help 😊
Please Help
Thank you.
@Ahmedx @Ritaf1983 @amitchandak @parry2k
@Anonymous you can store the images at a publicly accessible place and then create a dynamic measure to get the respective image rather than using a bookmark.
Let's assume image names are:
Late.jpg
On Time.jpg
Blocked.jpg
and add a measure:
Image URL =
VAR __baseUrl = "<location where your images are>"
VAR __ImageName = __baseUrl & MAX ( Table[Status] ) & ".jpg"
RETURN
__ImageName
and set the category this measure as image URL, and now you can show this URL and based on the status the image will change.
Alternatively, you can store the images as base64 and use them from there. Check this link
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.