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!
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.