Power KPI Matrix: % values don't show correctly in 'Actual Value' field

Question

I'm using PowerBI's Power KPI Matrix and for the most part its working as expected.&nbsp; Most of my 'actual value' variables display correctly.&nbsp; However, I have one variable that is a percent value (like a profit margin value) that displays correctly in the 'row-based-matrix' file but doesn't show correctly in the PowerKPI table.&nbsp; Right clicking on the 'actual value' field in the visualization panel shows the default action as 'sum' which is good for most of my variables but doesn't display correctly for a % value.&nbsp; If I change the 'Actual Value' variable in the visualization panel to 'average' the % value displays correctly but the other non-% values don't.&nbsp; If this were a typical PowerBI table, I would set this % variable to 'average' and the others to 'summed.'&nbsp; Is there a way to turn on 'average' for just one of the metric values?&nbsp; Thanks.&nbsp;

v-evelk · Answer

Hello,&nbsp;Could you please share some screens or/and data to better understand you case?&nbsp;Thanks!&nbsp;Evgenii Elkin,Software EngineerMicrosoft Power BI Custom Visualspbicvsupport@microsoft.com

jboyd170 · Answer

Thanks,&nbsp;v-evelk&nbsp;, looks like the sample problem file has the same problem.&nbsp; If you look at the 'satisfaction' value in the table, it shows 45% to 47% depending on the country slider which is correct.&nbsp; However, if you clear the country slider, the satisfaction value is 1.40, which appears ot be the sum of the individiual country values.&nbsp; This is not correct -- the value should be calculated differently.&nbsp; &nbsp; I couldn't find an easy way to upload the screen shot of this.&nbsp; Thanks for your help.&nbsp;

v-evelk · Answer

I see that Power KPI Matrix doesn't care about grouping function in case to show Actual value, there will be always show the latest value from the rows. Moreover, if actual value field uses something except SUM grouping a corresponding metric will be excluded from visualization (not sure, may be a bug).

Also, if you switch to Table visual and clear the Country filter you will see that the latest percentage in the table is exactly such that Actual Value shows. It means that KPI Matrix doesn't summarize it, this was done by Power BI.

Regarding all of this, I suppose that it is better to transform data to format you need (calculate average % by DAX) before give them to Power KPI Matrix.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]

jboyd170 · Answer

Thanks&nbsp;for your reply.&nbsp; &nbsp;I agree with you that when I clear the county filter in the table view, the resulting value for satisfaction is 1.4.&nbsp; It appears to sum the values of each county (.45, .45, .45) similar to the other categories.&nbsp;&nbsp;If I change 'satisfaction' value from 'sum' to 'average' in the column category for the column-based metric table, the satisfaction doesn't display in the table, which i guess is correct.&nbsp; The visual doesn't support averages as values.&nbsp;&nbsp;I don't see a way to trick PowerBI to pre-calculate averages so they are displayed correctly.&nbsp;&nbsp;&nbsp;I can imagine many cases where I want a KPI based on an average value (% profit margin, % sales by region, etc) which unfortuately, is not available in this visual.&nbsp; &nbsp;&nbsp;I would hope that the visual could be enhanced to show averages in the table.&nbsp; Until then, this visual is not useful for my application.&nbsp;&nbsp;Thanks again for the reply.&nbsp;

v-evelk · Answer

I am not sure whether it possible to implement or not but I added it to the visual backlog so, we will investigate and probably include in the next visual releases.&nbsp;Evgenii Elkin,Software EngineerMicrosoft Power BI Custom Visualspbicvsupport@microsoft.com

Forum Discussion

Power KPI Matrix: % values don't show correctly in 'Actual Value' field

7 Replies

Related content

Budget, actual and variance matrix

Totals not summing up correctly within matrix

Total % not showing correctly

Table Filters dates correctly but matrix show blank

Matrix table