How to set up dynamic goals through images or icons + double axis barchart

[Anonymous]

Hi everybody,

I hope this message finds you well ?! 😁

I'm trying to make a vizualisation where my "target"/icon's colors changes depending on a created column:

(if [Number] < [Target], "Red", "Green").

I use this to have a quick view if I reach my goals or not. Do you have any tips to do it? I've tried with Unichar function but it doesn't work (see the first picture).

My second question is about making a double axis barchart, but not on the same "level" (see the second picture). I've tried on Power BI but the result stays on a single line (not on 2 lines like the second picture):

Thank you in advance for your help and have a safe day !

Fabien

[amitchandak]

@Anonymous , Try if Tornado  chart can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380768?tab=Overview

[Anonymous]

Hi @amitchandak ,

Thank you for the answer, but I've already try a tornado chart. The problem is that I've 2 calculted measures for each rows in the dataset, so I can't put a dimension separating the two values.

Do you have a solution for my first problem about the use of dynamic icon/image? I've seen your tutorials on Youtube but I haven't found a solution.

Thank you for your time !