Solved: Conditional formatting on image

Anonymous · ‎06-12-2019

Hello,

I need to do a workaround for the Tachometer custom visual so I thought about the possible solutions and have figured that if I put an if to show an image only when the certain condition kicks in, the user will be happy. But how it is possible to use if for an image to show up when the Actual>1.5 * Targets and other times disappear?

Many thanks in advance!

parry2k · ‎06-12-2019

@Anonymous you can write a measure for image url and assign url only when your condition is met

Image = IF( [YourMeasure] > [your value], "image url" )

Make sure change date category to image url on modelling tab.

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.

View solution in original post

parry2k · ‎06-12-2019

@Anonymous you can write a measure for image url and assign url only when your condition is met

Image = IF( [YourMeasure] > [your value], "image url" )

Make sure change date category to image url on modelling tab.

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.

Anonymous · ‎06-12-2019

Thanks a lot @parry2k ,

2things here:

1-What is Date you mentioned here mean? I don't get it!

2-When you say "image URL", how I can give the address of a local file?

Looking forward to hearing your reply back

Thank

parry2k · ‎06-12-2019

@Anonymous sorry it was type, it is data category not date category.

Preferr way to show image is to have it in cloud but you can also load it from your computer, here is a video which can help you.

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.

Conditional formatting on image

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly