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
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

 

 

  • 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.