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.
@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.
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
The Current Value in table is 905 (this value is from May)
But what I want is the value from June (Latest Value)
Oh God still not able to understand (sorry), Can you please share table data Structure and Power BI Desktop Visualization window. Thanks
@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
Can you please illustrate how did you overcome the problem of the last value showing instead of aggregated value in Actual Value Column?
Which values you would like to display as percentage in your screenshots?
Please try to select the column or measure, then change format option:
@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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.