cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
craigrach Frequent Visitor
Frequent Visitor

Area Chart Troubles

Hello,

 

I am trying to create an area chart in power BI.  Seems simple right?

 

I am working with 5 data columns in my data set.  They are titled fiscal year 2015 through fiscal year 2020.  The sum of each of these columns provides me with a unique data point that can be plotted against the y axis.  The issue is, that I don’t have another data column to use to separate the data into individual years on the X axis (2015, 2016, 2017…ect).  As a result my data points appear stacked in a straight line, one on top of the other.

 

Any ideas on how to accomplish this?  Is there a way to assign each Value column to a unique year with restructuring my source data?

 

Thanks.

4 REPLIES 4
Super User
Super User

Re: Area Chart Troubles

Try Unpivoting your data in the query editor, this will give you two columns, one with values of "Fiscal Year 2015", etc. and the other with the Value. You can still create sum measures and you should be good to go.

 

Unpivot columns is found under "Transform" tab. Select all of your columns and then hit "Unpivot Columns".


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

craigrach Frequent Visitor
Frequent Visitor

Re: Area Chart Troubles

That makes sense. But as I am applying the unpivot to each of the columns, the overall dataset keeps getting smaller.  By the time I get to the last column, I only have 8 rows left in my table that started at several thousand.

 

Thanks again.

craigrach Frequent Visitor
Frequent Visitor

Re: Area Chart Troubles

 

 

Well I've made it this far.  The unpivot was successful, but when I change the data above into the area chart I am looking for, all I get it a single X category when I actually want 6 (2015-2020).

craigrach Frequent Visitor
Frequent Visitor

Re: Area Chart Troubles

https://www.dropbox.com/s/bjpdncbgvf8pqfo/Untitled1.png?dl=0

 

The above image conveys what I am trying to show, I just want to get it into one chart instead of 5.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,514)