I have followed your instruction and created kpi in powerpivot.
When I import to PBI desktop, the kpi (or the pivotpivot table) is not found. But when I import to PowerBI onilne, the kpi is there.
May I know how to correct this?
Are you using the latest version of the PBI Desktop?
2.34.4372.501 64-bit (April 2016)
If not you may have to turn on the Preview Features (see Vanessa's post and picture on Page 1)
Hi, I'm trying to create traffic light indicator and I have data model already created using Powerviot.
After created data model using Powerviot, I have created KPI spreadsheet and this is loaded to PowerBI.
However, when I create table using data source loaded, it does not show traffic light indicator but showing "-1" or "1" value instead.
Can anyone let me know how should I go about this?
Thanks in advance!