KPI shows wrong value

[Anonymous]

Hello,

I am creating a KPI but it only captures the number of the last month.

First, I have created a Column Chart Axis - Month (from Sort-Month tbl), Values - New Employee ( from Employee tbl) and then I sorted it out by Month. The column chart shows the correct values per month from Jan to Dec. Then I clicked on the KPI and the value shows 14 which is the value from Dec. only and should be 184 from Jan to Dec. The indicator New Employee is already in SUM.

I've already followed the tutorial here but my problem is that it's showing a wrong value in the KPI

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

[Ashish_Mathur]

Hi,

Share the download link of your PBI file and show the problem very clearly.

[Anonymous]

Hello Ashish,

Here's the pbix file

https://www.dropbox.com/s/yf8ykl3zszggdg0/KRI%20Problem.pbix?dl=0

[Ashish_Mathur · Accepted solution]

Hi,

I think this is what you want.  Download the PBI file from here.

[Anonymous]

Thank you @Ashish_Mathur for the measure you created. I've learned another technique. Thank you so much.

[Ashish_Mathur]

You are welcome.

[Anonymous]

Apologies for not being clear, I mean the green background image if the goal has been reached or the red one if it didn't 🙂

[Ashish_Mathur]

Sorry i would not be able to help with that.

[Anonymous]

it's okay. Thank you @Ashish_Mathur !

[Anonymous]

Hello @Ashish_Mathur ,

I have applied your solution in my dashboard. I just have a question, do you have any idea on why the trend axis is not showing? I turned it off and on a few times but it's still not showing. Thank you 🙂

[Ashish_Mathur]

Not sure what you mean by that.