Skip to main content

Power BI

Completed

When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Vote (5064) Share
Power BI User's profile image

Power BI User on 18 Aug 2015 20:04:15

KPI Red/Yellow/Green Indicators were available in Power Pivot. With the new Power BI Desktop this feature is not available anymore. If you import from PP to the Desktop it converts the RYG Indicator Dots to a number. Will the Red/Yellow/Green Indicators be added back to PowerBI Desktop? If so When?

Administrator on 19 Jul 2019 09:53:15

It's very exciting to be able to close this idea! With the July 2019 release of Power BI Desktop you can now create icon sets that show status indicators, in fact a whole range of icons, in your table and matrix visuals. You can read more in Amanda's blog post here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#iconSets For those of you who want to have the KPI definition stored in the model itself, please vote on this idea for us to track interest there: https://ideas.powerbi.com/forums/265200/suggestions/38181139 Thanks for engaging with the ideas forum and helping us build the product you need!

Comments (235)
Power BI User's profile image Profile Picture

Brian on 05 Jul 2020 22:53:36

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

PLEASE...We need icons and trend arrows

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:46

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Yes icons

Power BI User's profile image Profile Picture

Ketan Deshpande on 05 Jul 2020 22:51:01

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Conditional formatting is really necessary ! Its a basic necessity for any data visualization developer. Need it badly in Power BI

Power BI User's profile image Profile Picture

Laura L on 05 Jul 2020 22:51:01

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

I agree! This is needed!

Power BI User's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:50:55

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Not only the text, but also the background of the cell in a table/matrix, such as:

20 = green

Power BI User's profile image Profile Picture

Wilson Sarmiento on 05 Jul 2020 22:50:11

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

I totally agree. This is a great functionality in PowerPivot that Power BI is missing and it's absolutely necessary...

I hope you can add it as soon as possible!

Power BI User's profile image Profile Picture

Paul Turley on 05 Jul 2020 22:49:09

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

The KPI feature has been a standard in SSAS and Excel for many years. I was surprised that it wasn't part of Power BI from the beginning. I'd also like to have the option to calculate the Status and Trend properties separately, like we can in SSAS but just tie them to a hidden measure (e.g -1, 0, 1)

Power BI User's profile image Profile Picture

Jade Michelle Sue on 05 Jul 2020 22:48:49

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Agree that we need to conditional format on a text field. Otherwise I need to do a hack to convert text to an arbitrary number which is meaningless to business users to have that number on a color background. In the end, my manager prefers non-conditional formatting and just display the text otherwise until this is fixed.

Power BI User's profile image Profile Picture

Cristianrus on 05 Jul 2020 22:48:48

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Not complete!
Very important.... This is a necessity: Incoporating KPI visuals that can be expressed in a Table. Basic and relevant...!!! Please. I noticed that this need has been posted for a long time period but I can't understand why it is not solved yet. I strongly recommend to incorporate this basic but subtantial improvement for further versions. Thanks, Felipe Baritto.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:47:57

RE: When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

Creo que sería un agregado de suma utilidad poder incluir caracteres gráficos como datos de una tabla ... para ello quizás alcance con poder utilizar otra tabla de caracteres, por ejemplo, Wingdings.

Muchas gracias por la atención !!!

Dany