When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?
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?
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!
yeah this isn't complete. it only works in the table visuals not in single or multi cards. it's also not in power bi desktop...
Daníel Hjörvar commented
Got 3 votes from me. Colored columns in a chart should have the ability to be value based. E.g. if the value is below zero the column turns blue, above zero then red.
This is a complete must for measuring KPI's based on targets and goals.
Specifically when using card and guage reporting!
Not sure why this is marked as completed. When will we be able to create KPI Red/Yellow/Green Indicators in PowerBI Desktop?
William TAPSOBA commented
I am very surprised to see that KPI are not in Power BI 2.0. Hope it will be included in the next release
Robert Barbrow commented
This is not completed unless I can use it in BI Desktop. I shouldn't have to use a bunch of other tools
The november update allows us to display KPI. When can we create some KPIs in Power BI Desktop?
Mike H commented
I appreciate that KPI's can now be exposed in a dashboard, however, being forced to use SSAS tabular, MD or Power Pivot is too complicated for most peoples needs. Why do I have to use 2 or more different tools to get a KPI?
It really needs to be part of the PBI Desktop.
Dave Olsson commented
I am experimenting with the customization synoptic visual, make an image with 5 boxes, each box is a color etc... No joy yet, but it's a great custom viz.
I need this too. A KPI visual right out of the box will be very useful to create powerful and meaningful dashboards.
Jon Capezzuto commented
As @Haegi mentioned, check out the Card with States custom visual that was released 10/18.
Was easily done in Power View. Got Lost in the conversion?
Tom Michaels commented
I need this, and also need to be able to use colors within tables of information to highlight data elements.
I thinks a preview is now available with the latest version of PowerBI Desktop
Patrick Willborn commented
Would be pretty useful if the text colour of a KPI is related to a defined goal setting, i.E. having a goal "0" and if the shown value is 20, it will be green, if it is -10 it will be displayed red.
Tas Ranson commented
A general traffic light indication that allows up to 5 indications (using 4 break points) as was available in Excel would make sense. We should be able to configure colours for the various stages and change the symbol as well.
G Aravindan commented
when will KPI with Red/Yellow/Green color for threshold limits come?
Cool and useful! Support
This feature is a must and without it in Power BI definitely takes away from all of the other new features in Power BI. Even Power View has KPIs now.
Eric Sergerie commented
Hability to create KPI like in PowerPivot for Excel is a must. Also, KPI graphics like stoplight and/or red/green arrows would be great.