Forum Discussion

sdegroot's avatar
sdegroot
Helper I
8 years ago

kpi

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!

 

 

 

 

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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's avatar
      sdegroot
      Helper I
      8 years ago

      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!