How to change an image as per a column value of a table in power BI Desktop?

[AnkitaChatterje]

Hi,

I have some saved images of a visualisation in 3 different color modes viz. "Green", "Yellow", "Red" & "Black". Also, I have a table where there is a "Color" column which states the current color of the visualisation viz. "green", "yellow", "red" or "black". 

I want to set a condition in power query that will display the visualisation accordingly-

a) If the column value is "green", then display the visualisation with color mode "Green" OR

b) If the column value is "yellow", then display the visualisation with color mode "Yellow" OR

c) If the column value is "red", then display the visualisation with color mode "Red" OR

d) If the column value is "black", then display the visualisation with color mode "black"

Sample pic of the visual with color mode "Green"

Pic of data table with "Gauge_Color" column

Kindly tell me how I can schedule the visualisations as per the above conditions.

[v-piga-msft · Accepted solution]

Hi @AnkitaChatterje,

Based on your description, do you want to create a custom conditional column in Query Editor?

If it is, you only need to select Conditional column and add rule. You could type you image url to the output value.

In addition, if you want to show image in Power BI, you need to change the Data Category of URl column to be image URL under Modeling.

If you need further help, please share your desired output and your data sample, so that we can help further investigate on it?

Best Regards,

Cherry

[AnkitaChatterje]

Thanks for the help. I have solved my problem using this approach. But is it possible to do the same thing with local images stored in device?