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

Phillip on 05 Jul 2020 22:40:59

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

We should also be able to change the font and font size of the numbers in the KPI. Maybe combine the following suggestion into this one....
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17887528--kpi-visual-element-does-not-allow-to-change-numb

Power BI User's profile image Profile Picture

Felipe Baritto on 05 Jul 2020 22:40:16

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

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

Markus Könemund on 05 Jul 2020 22:39:47

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

'@Sunbeam21: i need excactly the same features:

If table contains Text for status eg. red, yellow, green then the text should be in this colour....

Power BI User's profile image Profile Picture

Ter Bo on 05 Jul 2020 22:39:46

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

We absolutely need to be able to format table cells or rows based on a text value, for example, values such as: "On Time", "Late", "Completed". Formatting based on numeric values is not adequate

Power BI User's profile image Profile Picture

Tom Blodget on 05 Jul 2020 22:39:17

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

A red-green KPI is green when the value equals the red-green goal. A red-yellow-green KPI should behave similarly.

Power BI User's profile image Profile Picture

Stanislav on 05 Jul 2020 22:38:42

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

Agree on this 100%

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:38:34

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

Would be great to not have to build this into the model every time.

Power BI User's profile image Profile Picture

Onboarding User on 05 Jul 2020 22:38:11

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

Would be a great feature!

Power BI User's profile image Profile Picture

Sunbeam21 on 05 Jul 2020 22:37:27

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

Agree to original requirement and as others have commented would like to colour cells based on text entries eg red, amber, green.

Power BI User's profile image Profile Picture

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

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

When is this going to be complete then?