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

marcelo on 05 Jul 2020 22:22:39

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

Either that or be able to format one field based on the rule applied to another field. For example if the diference of value and target is above 0, apply the formatting not only to the diference field but to any other field I specify. Font formatting should be allowed too.

Power BI User's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:22:39

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

When doing conditional formatting for tables, we should be able to specify a non-fixed/constant value, such as a value that comes from another field.

In addition to that we should be able to specify a KPI coming from the analytical model itself. We could then have all the logic within the KPI in the tabular model, but then use that to conditionally format cells in a table rather than adding the KPIs as additional columns.

Power BI User's profile image Profile Picture

Niek Jetten on 05 Jul 2020 22:22:28

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

What is completer and How and Where can we find iT and when?

Power BI User's profile image Profile Picture

Patrick Willborn on 05 Jul 2020 22:22:28

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

Completed ??? Where? How? Did I missed something?

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:28

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

what does it mean?? We need to have the ability to create Kpis like in power pivot, so then you can monitor your business with 'alerts'S!!

Power BI User's profile image Profile Picture

Enrique on 05 Jul 2020 22:22:23

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

I don't get why we even have to vote for this, its inclusión should be natural.

Power BI User's profile image Profile Picture

Vanessa on 05 Jul 2020 22:22:10

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

This feature is a must.

Power BI User's profile image Profile Picture

Paulo Sergio Rocha on 05 Jul 2020 22:22:10

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

One easy way to have icons, arrows and any other image as a way to show meaning to a value is to give measures the ability to be set as a URL Image. I already have a model set up to show, grey, red, yellow, green and blue Icons according to % value.

The only thing missing is measures being URL image. It would work like a charm.

Since Power BI is about visuals, I don't understand why this is not implemented yet.

Power BI User's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:22:04

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

Conditional formatting of table and matrix cells is a MUST !!!!!

Power BI User's profile image Profile Picture

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

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

Could be possible to have custom images instead of green, yellow and red colors?