cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
borlip
Advocate I
Advocate I

Is there a way to add KPI to a report?

Is there a way to add KPIs to a report? 

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

1 ACCEPTED SOLUTION
AlexGorev
Power BI Team
Power BI Team

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

 

Alex.

View solution in original post

5 REPLIES 5
andre
Memorable Member
Memorable Member

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

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
Power BI Team
Power BI Team

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

 

Alex.

View solution in original post

Hi Alex,

 

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

konstantinos
Memorable Member
Memorable Member

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

Konstantinos Ioannou

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.