Forum Discussion

Toyota's avatar
Toyota
Frequent Visitor
7 years ago

power kpi column mapping doesn't work

I'm hoping someone can help me with a problem I'm having with the Power KPI visual.  My table is column based.  I can map the comparison value, KPI indicator index and value in the task pane (see bel...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Toyota

When i enter 0 in the "comparision value" , it shows blank.

Is this the same with your scenario?

Best Regards

Maggie

  • Toyota's avatar
    Toyota
    Frequent Visitor
    7 years ago

    Maggie,

     

    Yes, that is the same scenario as me.  However, I've had 0 in the comparison value fields for 1 week and the KPI status and column mapping was working fine until yesterday. 

     

    FYI, I have the latest versions of Power BI desktop and Power KPI.

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

      Hi Toyota

      I'm consulting with Product team to confirm whether it is by design or a bug.

      I will update if i get any information.

       

      As a temperary solution to let you show the the value with 0, here is workaround.

      create a measure

      Measure 2 = IF(MAX([comparison value])=0,"0",MAX([comparison value]))

      this measure is of Type Text, so don't use this measure to calculate other measures or columns (like [kpi status])

       

      Best Regards

      Maggie

       

       

      • Toyota's avatar
        Toyota
        Frequent Visitor
        7 years ago

        Thanks Maggie, but I think I wasn't clear enough. 

         

        The original image I posted is what I see when I'm mapping the columns.  After I hit "apply" and "back to report".  All of the KPI indicators and comparison values are blank whether the comparison value = 0 or something >0.