Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
It appears that in the last month or two, KPIs that were imported from an Excel data model no longer work correctly. Specifically, when refreshed due to a slicer or crossfilter, the color and symbol frequently do not match - thus leading to a completely inaccurate result and defeating the point of a KPI. Has anyone else noticed this? (I tried to attach a screenshot, but couldn't get it to work.)
Solved! Go to Solution.
This was an actual bug with the card visualization. A case was filed and the fix was implemented in the November 2018 release of Power BI.
Hi @Anonymous,
I was not able to reproduce. Would you please share your Excel workbook so that I can test on my side via importing it to Power BI desktop? Besides, on your side, does problem always exist when you open a new .pbix file and import the Excel KPIs?
Regards,
Yuliana Gu
It only happens when using the card visual. On all others that I've tested it works ok. And, to your question, yes, the only way to get the KPIs to work in the model is to import the Excel workbook from the beginning. On the flip side, you can get the same results by using a tabular model KPI with a card visual.
This was an actual bug with the card visualization. A case was filed and the fix was implemented in the November 2018 release of Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.