@vanessa Unfortunately you have to do this in PowerPivot and then import to PBI
the feature is described here => https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/
So ANYONE who wants to be able to create the KPIs inside PBI
Please Vote here
I tried the approach mentioned in the link, but I am not able to see the option Preview Features > Use KPIs from Power Pivot or SSAS Tabular in the Option and Setting tab. Is thia preview feature no longer available?
@vanessa It seems this feature has been enabled by default in the latest PBI - so don't worry it will work!
However don't forget you still have to create the KPIs in Excel PowerPivot and then import into PBI
That worked. Thanks.
But after importing the excel sheet, all my earlier report pages have disappeared and not all tables/files have been migrated. Is there a reason for this? Do i need to recreate all the pages again?
@vanessa Yes the process is kind of frustrating.
Only Power View Excel Sheets get imported - and not even all Power View visualizations are supported.
That's why I encourage people to Vote and hopefully the PBI Team will get behind the Idea of KPIs inside PBI.
They just recently marked "Under Review" one of my Ideas - which will go great with KPIs
So hopefully it's just a matter of time
@vanessa I have not encountered this but I'll see if can duplicate it tomorrow - will let you know...
its strange though??? Is the rest of your data still there and only the KPI Measure(s) gone?