Forum Discussion
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. ...
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".
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).
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.