power kpi column mapping doesn't work

[Toyota]

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?

[v-juanli-msft]

Hi @Toyota

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

Is this the same with your scenario?

Best Regards

Maggie

[Toyota]

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]

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]

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.