Power KPI Matrix: issue showing percentages in "Target" column
Hello, I wanted some help with showing percentages in the Target column. I've been tinkering around with the Power KPI Matrix visual, and my current report looks like this: I'm having some difficulties with trying to make the percentages appear in this area (red circle). My target's table looks like this: It works fine for other numeric values, but for percentages, I can't get them to show up on the visualization. Any ideas on how to solve this? On that note, does anybody know how to show an indicator from the same period of the previous year using percentages (purple circle)? So, for example, I want to able to see my value column saying April 2018, there was a 92% fill rate, and on the left hand column which represents the last year to show April 2017, with a 85% fill rate. The closest I've gotten is to take an average of the percentages from the same period of last year: 08.2 YTD Prior = CALCULATE( AVERAGE('Operaciones'[08.2 Fill Rate (%)] ), SAMEPERIODLASTYEAR( DATESYTD(Fechas[Fecha] ) ) ) Thank you for the feedback.Dataset with value NULL is showing the last KPI value rather than NULL
When a KPI is pointing to a dataset whose vlaue changes to NULL, the value in the KPI stays as the last non-NULL value reported. I'd like it to update to NULL... or blank or zero by default. I do not want to create another measure that changes a NULL value to zero. I think this is just a bug that needs to be fixed. I am on PowerBI Report Server Version 1.1.6551.5155 (October 2017)... we do plan to upgrade to the latest version (March 2018) soon. If someone knows whether the latest version fixes this, I'd definitely appreciate the info! :) Kevin
