Showing results for 
Search instead for 
Did you mean: 
Uffan Occasional Visitor
Occasional Visitor

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 release 4/12/2019


v-evelk Senior Member
Senior Member

Re: Power KPI - Series



Sorry for the late answer.

Could you please send your report for analysis to ?


Kind Regards,


Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 115 members 1,729 guests
Please welcome our newest community members: