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

76385221 071d-42bd-9700-90ee70f9f704 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

7a116191 f4ac-4019-84d8-74e42884507d 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

dd1750f0 99af-490f-87dc-0e057830b8ea 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

6e8c8bac 52d8-4646-911b-4d5f47459ed3 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

1f7f2711 5819-e611-80e2-c4346bad91c4 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

5abec3ce 31a0-4158-a452-6ab30c061f14 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

1afb5152 6d67-40fd-8ef9-451a25719d09 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

636b1099 0e67-44d9-9878-0ce8cc1b8493 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

9f1d2468 393f-4be7-9bf8-a32286f3fed6 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

810a0d29 d278-49ad-91a8-74fdde13d993 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