Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

KPI shows wrong value

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