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

9f93ff71 ee47-453e-94ed-f249cbdc2d34 on 05 Jul 2020 22:09:06

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

As @Haegi mentioned, check out the Card with States custom visual that was released 10/18.

Power BI User's profile image Profile Picture

82be5723 104f-40f6-bcfc-9447ab2f17f4 on 05 Jul 2020 22:09:04

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

Was easily done in Power View. Got Lost in the conversion?

Power BI User's profile image Profile Picture

Tom Michaels on 05 Jul 2020 22:08:29

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

I need this, and also need to be able to use colors within tables of information to highlight data elements.

Power BI User's profile image Profile Picture

7e0436ff 902b-489e-b9ca-37625de32950 on 05 Jul 2020 22:08:09

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

Hello,

I thinks a preview is now available with the latest version of PowerBI Desktop

Power BI User's profile image Profile Picture

2ae54c36 9ba2-4eb7-b9cb-5af1e9d3edea on 05 Jul 2020 22:08:04

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

Would be pretty useful if the text colour of a KPI is related to a defined goal setting, i.E. having a goal "0" and if the shown value is 20, it will be green, if it is -10 it will be displayed red.

Power BI User's profile image Profile Picture

117e9a71 15fd-4d53-96b5-a44d199976f3 on 05 Jul 2020 22:05:24

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

A general traffic light indication that allows up to 5 indications (using 4 break points) as was available in Excel would make sense. We should be able to configure colours for the various stages and change the symbol as well.

Power BI User's profile image Profile Picture

71b923d8 6412-4b69-ad7d-d16c786f8d65 on 05 Jul 2020 22:04:59

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

when will KPI with Red/Yellow/Green color for threshold limits come?

Power BI User's profile image Profile Picture

9c4e21b0 cb3d-4311-b6a5-0e2d998a47c2 on 05 Jul 2020 22:04:19

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

Cool and useful! Support

Power BI User's profile image Profile Picture

88401184 cbd4-4f4d-97a1-d7b713e01e4e on 05 Jul 2020 22:04:18

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

This feature is a must and without it in Power BI definitely takes away from all of the other new features in Power BI. Even Power View has KPIs now.

Power BI User's profile image Profile Picture

f0520a0e 82a1-443c-ab7e-d05ce3c2e01d on 05 Jul 2020 22:04:17

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

Hability to create KPI like in PowerPivot for Excel is a must. Also, KPI graphics like stoplight and/or red/green arrows would be great.