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

04bee1de dd7a-44ed-9dcb-ea9613a7230c on 05 Jul 2020 23:10:33

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

Please add asap

Power BI User's profile image Profile Picture

5c08d93d 4799-4156-9ec3-111405f4cc30 on 05 Jul 2020 23:10:00

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

Please, add this to the possibilities.
It must be somewhere in the hidden features, because I still have one table in my model still supporting this Kpi feature from Excel in one of the previous versions.
It still works, but cannot be modified or applied on other measures.

Power BI User's profile image Profile Picture

2f95b2b3 f8ef-477a-8cff-e53c6859071f on 05 Jul 2020 23:09:26

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

When can we have text based conditional formatting on Power BI? It is such a basic use case. I wonder if we have any workaround to format a cell color based on the text it contains. Please let me know if anyone has any idea.

Power BI User's profile image Profile Picture

0109a589 1b32-4f73-b0ca-cdac6c4b4d8a on 05 Jul 2020 23:09:11

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

text-based conditional formatting should be must have!

Power BI User's profile image Profile Picture

95a7efeb 5052-4137-871f-851e18b6a141 on 05 Jul 2020 23:08:48

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

While the UNICHAR DAX functionality works, it's pretty yestertech in a "graphical" environment.
I don't believe icon sets for KPIs have not been included natively in Power BI.
Please add them asap.

Power BI User's profile image Profile Picture

f33d1efd 4be7-486d-a83e-71c6718d6c48 on 05 Jul 2020 23:08:05

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

Please add this to the app

Power BI User's profile image Profile Picture

46f82d4d 27a2-4327-92e4-0113f23c76e1 on 05 Jul 2020 23:07:59

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

I'm struggling to understand why you have released a half baked feature. Text based conditional formatting is surely a minimal update. All I want to do is something that would take seconds in Excel and that's colour code a RAG status

Power BI User's profile image Profile Picture

6a5fe84c b1b0-4621-a03b-12237491c5e8 on 05 Jul 2020 23:07:33

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

text-based conditional formatting should be must have!

Power BI User's profile image Profile Picture

c6210f24 4981-4a5d-bd6e-6fdc2e6e3cad on 05 Jul 2020 23:07:09

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

We definitely need text-based conditional formatting!

Power BI User's profile image Profile Picture

8bb429e1 c827-448c-b43e-05fad19db7e1 on 05 Jul 2020 23:06:36

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

I wonder how it comes not to have the text based conditional formatting supported in PowerBI ?!!!