kpi

[sdegroot]

Hello,

I am currently using a KPI and it has worked successfully when based it off a percentage goal. Unfortunately, some of the values purposely have no goal and instead of Neutral, the colour coding is formated as the "bad color." 

Can someone help me with the DAX measure for this?

Thank you!

[v-juanli-msft]

Hi @sdegroot

After testing, i can't make the same visual as you required.

According to this post, "the Neutral colour is for when you have two target values, if your measure falls between the two it is Neutral Colour, if it is above the higher target it is Good Colour, if below the lower of the two targets it is Bad Colour".

However, blank value can't make sense this way, so i modify the blank value to an alternative value to show neutral color.

Column = IF(ISBLANK([goal1]),[percetange]-0.01,[goal1])

Column 2 = IF(ISBLANK([goal1]),[percetange]+0.01,[goal1])

Best Regards

Maggie

[sdegroot]

Hello Maggie,

Thanks for looking into it! Were you able to use this in DirectQuery mode too? I wasn't able to use it and I know DirectQuery is very sensitive to adding new columns.

Thanks!