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