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

c935c59d 6f0e-48ab-b20f-c46403545b3e 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

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

1fcdc24c 55ba-49e8-a8c0-8d52fab0a85a 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

2ae54c36 9ba2-4eb7-b9cb-5af1e9d3edea 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

e5826289 5f66-44d3-8dd0-ac718db12725 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

9b50dde2 0bce-41ba-ae6f-7665aa6fdce3 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

66b85007 e10a-4b39-885e-f37a84d81718 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

4c8250dc a15a-4058-8e61-84e14c3adbe0 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

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

65cae91f d414-4615-b6ef-ac285824c555 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?