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 below).  However, once I click on "back to report" the KPI status and comparison value fields are blank (I did click on "apply" before going back to report). 

 

Previously, I didn't have this problem.  It only started happening once I added the third metric "Total issues YTD". 

 

Does any have any suggestions?

 

 

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity 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
        Icon for Community Support rankCommunity 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