cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

 

image.png

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).

 

image.png

 

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

1 REPLY 1
v-evelk Senior Member
Senior Member

Re: Power KPI - Series

Hi,

 

Sorry for the late answer.

Could you please send your report for analysis to pbicvsupport@microsoft.com ?

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 139 members 1,819 guests
Please welcome our newest community members: