Power KPI Matrix Actual Value

[iNuii]

Hi.

I got a problem with using Power KPI Matrix, that the Actual Value which show up in the matrix is not the latest one,

and I try to setting it as Last but no dropdown shown as Last value.

please help....

[zlokesh]

Hi @iNuii,

                 Can you  please put the detailed scenario with screenshot (or example) so that we can get idea. Thanks

[iNuii]

@zlokeshplease find in the screenshot you will find the current value that shown and the 2nd screenshot will show as the value that shown in the table is not a latest one.

Thank you,

[zlokesh]

Hi @iNuii,

                            Still not cleared the picture, but as per my understanding i think you select the percentage as value instead of actual number.  ( I think you are talking about the KPI Status value  not Net Income and First Target).

It would be great if you highlight the values from both pictures. Thanks

[iNuii]

@zlokesh

Okay...

The Current Value in table is 905 (this value is from May)

But what I want is the value from June (Latest Value)

Thank you,

[zlokesh]

Hi @iNuii

Oh God still not able to understand (sorry), Can you please share table data Structure and Power BI Desktop Visualization window. Thanks

[iNuii]

@zlokeshSorry for late, as the previous issue I already fix it. but now I got a new issue.

is it possible to show some value in matrix as percentage, I meant not all in the column (ex. value in current value and in comparison value)

Thank you in advance

[AhmedCCC]

Hello!

Can you please illustrate how did you overcome the problem of the last value showing instead of aggregated value in Actual Value Column?

[zlokesh]

Hi @iNuii,

               Please go thorugh below image, Hope will solve this. Thanks

[iNuii]

Sorry @zlokeshI use the custom visualization (Power KPI Matrix) and I can't see menu for changing format

Thank you

[guest9876]

Do you mind me asking how you imported the Target values? 

[v-qiuyu-msft]

Hi @iNuii,

Which values you would like to display as percentage in your screenshots? 

Please try to select the column or measure, then change format option: 

Best Regards,
Qiuyun Yu 

[iNuii]

@v-qiuyu-msft Thank you, I already tried as your advice, but the value is disappear. I think it may from the limit of visualization that cannot use percentage to calculate.