cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StidifordN Regular Visitor
Regular Visitor

Dealing with horizontal figures

Can PowerBI deal with figures populated horizontally?  Example of data provided

 

this are figures populated by a team for month on month savings.  Will be creating pretty simple graphs from it but will be month on month and some cumulative.

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dealing with horizontal figures

When you import the data set, you have an option in the Query Editor called "Unpivot".  This will let you convert the data into records that will better suit how you will create your reports.

 


   

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

Proud to be a Datanaut!


   


6 REPLIES 6
Super User
Super User

Re: Dealing with horizontal figures

When you import the data set, you have an option in the Query Editor called "Unpivot".  This will let you convert the data into records that will better suit how you will create your reports.

 


   

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

Proud to be a Datanaut!


   


StidifordN Regular Visitor
Regular Visitor

Re: Dealing with horizontal figures

Fantastic!

Now that the Dates are the attribute - can I simply reclassify this column as a Date or will this cause issues?  The team intent to continue to manipulate the background data so if changing it to a date will cause issues with regular updates I don't want to touch it.

Super User
Super User

Re: Dealing with horizontal figures

As long as all the values in that column are something that can be converted into a date, or is a null, you should be able to make that column a Date or DateTime value.  If you have troubles, you can put in some steps to clean up the data a little before doing the conversion.


   

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

Proud to be a Datanaut!


   


SL2019 Frequent Visitor
Frequent Visitor

Re: Dealing with horizontal figures

Hello, 

 

What would I have to do if I have to combine multiple files that are in this horizontal format (1 file for each year of data)? When combined and loaded into PowerBI, these two files are stacked on top of eachother. If I unpivot the dates based on the first file that appears on top, I am unable to unpivot the second set of dates from the 2nd file.

 

 

1st File: 

file 2.PNG

 

 

2nd File: 

file 1.PNG

 

StidifordN Regular Visitor
Regular Visitor

Re: Dealing with horizontal figures

I think you need to post an example/sample of the different datasets to get a concise answer.

SL2019 Frequent Visitor
Frequent Visitor

Re: Dealing with horizontal figures

Can do! Thanks for the tip; I've edited my original post.


@StidifordN wrote:

I think you need to post an example/sample of the different datasets to get a concise answer.