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

f2c9bca6 fb45-42b9-9b38-2481bdc674be 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

5ea5d5a9 1375-4bc3-b70e-ee907301953c 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

1bfc1719 884f-4d08-970e-7130c2f62196 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

4f74baf7 b903-4640-a4a0-98f1b684f3bb 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

1bba19ab ef6e-4983-ad26-f5921c5defc9 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

3f0faf44 7eab-43dd-8028-b787cc8f2ba2 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

b411b506 ca78-403a-976d-d6d718df98be 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

55e90c01 fb03-45e7-a78a-5df3a9bf4fae 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

409a5cf1 29ed-4639-adc8-7c7d635813e5 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

4dc23bf0 7e63-47d6-9cd5-e6a34a06380d 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?