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?
Hi everyone! To give you an update here, we’ve begun work on this feature!
The first step will be bringing icon sets as a conditional formatting option. You’ll be able to set rules and icons, very similar to what you can do in Excel today. We want to get this out to you quickly, so it’ll be available in table and matrix visuals only to begin with.
Based on the comments on this thread, we’re focusing on the indicators first and looking for feedback on how soon after we need to follow with model-based KPIs. Please keep letting us know in the comments if you need model support for this too!
Thanks for your patience and for engaging and voting!
Matt Moos commented
Conditional formatting options for date fields is highly requested.
Would be nice to be able to format the background color based on dates.
Ex : today-7 days : orange / More than seven days ago : red
A much have Feature in Power BI Desktop which will make Power BI Developer life much easy. Thanks
Mike Foss commented
Please Make sure this is included in the Power BI Desktop report server version as well as added to function on the report server also. This is often missed when you guys make updates since the non report server power bi desktop pbix's don't function on report server.
It Will be very useful if this color Red/Yellow/Green indicators can be put behind of the Line or Bubble charts as border for the chart Cones the same as we have possibilities in Excel Combo Chart
Hi Will - it's a must have feature for us - we have designed a simple dashboard with our KPIs and simply want to show if we are positive growth or negative growth for the time period
yes please. In the model too.
Paulo Sergio Rocha commented
I solved all my KPI problems when a measure could be set as a URL image and now with the latest updates in conditional formatting too. But it still would be interesting to have a built in feature.
I would like model support for this too.
Please look into the size of the KPI as well. As we cannot change the size we are currently as a work around using the table visual where we can set the size as we want. The we get the desired layout if we do not show totalts. Pleeeease look into this. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15679131-kpi-customization-font-size#comments
STOPLIGHT FEATURE PLS.
any update about this idea?
While I agree that KPI Red/Yellow/Green Indicators is a great feature to have, if you are not connecting to a tabular model but this will not resolve the dynamic KPI threshold issue, whether you are connected to tabular model or not
Please see http://www.mssqlgirl.com/dynamic-kpi-threshold-in-tabular-or-power-pivot.html
We do have a workaround to overcome dynamic KPI threshold issue by creating measure as a SVG and categorize as an image URL but this does not work if you connect to tabular model or live connections to databases
Please vote for below link as this will be a great workaround to overcome this problem
Greg Lloyd commented
Any Update on this feature?
David C commented
No built-in feature for colored KPI indicators. Advance Card unichar arrows don't display properly with Internet Explorer. It's almost disrespectful that this feature isn't added by default.
You can currently add KPI indicators to Power BI models using Tabular Editor, however it would be nice if you could do this natively within Power BI.
Hi Kim. Could please provide an update to this?
Jed Hansen commented
As many others have mentioned, date comparison conditional formatting is a huge value, with numerous applications. Please add.
Please add this functionality. I was unhappily surprised to find it is not available in Power BI yet.
Frank Radewagen commented
We absolutely need to highlight cells based on it´s textual content for Management presentations. It´s hard to tell a Manager that we have a great new tool, but unfortunately we are not able to define conditional formatting for the cells.