Is there a way to add KPI to a report?

[borlip]

Is there a way to add KPIs to a report? 

Power Pivot has it but I can't find it in a designer...

[andre]

there is a hack that allows you to kind of have a KPI in your report.  you need to create three variables for a KPI that return 1 or null for either green, red or yellow.  then you use those variables as sources of a pie chart and you format the pie chart accordingly to render each variable in the correct color.  then if you size the pie chart very small, it will look like a KPI

Again, not very elegant but works for now

[onageeb]

Hello andre,

     Thank you for your answer, am new to Power BI, i understand what you're saying but can't do it correctly.  am on a tight a schedule and i need your solution. So, if you please provide an example for how to do it or elaporate more with steps , i would really appreciate it.

Thank you in advance.

[AlexGorev · Accepted solution]

This is something on top of our minds and we are working on this...

Alex.

[Anonymous]

Hi Alex,

It is more than 2 years now. Is it still on top of your minds and working on it?

[konstantinos]

You cannot create KPIs in PBI desktop yet...The workaround is to use excel powerpivot & powerview and then upload it to the service..keep in mind you need to keep using the old visual rendering engine ( old report canvas )...The arrows symbol not showing upin the new report canvas..