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
Ross73312 Super Contributor
Super Contributor

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!


   


View solution in original post

6 REPLIES 6
Ross73312 Super Contributor
Super Contributor

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!


   


View solution in original post

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.

Ross73312 Super Contributor
Super Contributor

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

 

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


 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 198 members 2,213 guests
Please welcome our newest community members: