Power KPI - Series

Hi Folks,

I've ran into a strange problem with the power KPI visual. I have a table that has row categories (gender) and a column total. The data is in the following format

Year, Month, Gender, Total

2009, 1, Female, 12000

2009, 1, Male, 11000

2009, 2, Female, 12005

2009, 2, Male, 11001

and so on. The table holds the data for the period 1-Jan-2004 to 1-Sep-2019. I was trying to display line trend of the each category of gender along with the % variance between the two over time. In the first instance, I created two measures to calculate totals for each category and drag them into the power KPI visual along with the date. No problems there

I tried another way to achieve the same, so instead of creating two measures, I dragged the total field into the visual Value, the gender category column in the Series and date on the axis. For some reason the graph just doesn't show any trend after end of 2012. But, I can see the data past 2012 upto 2019 in the data table used by the visual (as you can see int the picture below).

Any thoughts on what might be going on? I am using the power bi desktop version 2.65.5313.1562 64-bit for the power BI reporting server (all of our reports are hosted in house on the reporting server). power KPI version 2.0.0.0 release 4/12/2019

Uffan