Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tylerdv
Frequent Visitor

Rows not columns

Hey all! New PowerBI desktop user here.

I am currently working on reporting for sales and conversions.

 

My big issue is all my data runs the opposite way that PowerBI likes. adding new data to columns, rather than adding a row (due to the way data is presented. (see below for example)

 

Is there an easy way to change power bi to look at rows and not columns? I will be adding data frequently to this data set as well 

 

 29-Jan29-Jan29-Jan29-Jan
 24-Jan25-Jan26-Jan27-Jan
Total Dials338369391409
Total Decision Maker Contacts117130116136
Contact %35%35%30%33%
Total Presentations77908195
Presentation Rate %66%69%70%70%
A Acquisitions6143
     
B Acquisitions4644
- B Acquisitions categroy 03212
- B Acquisitions category 10000
- B Acquisitions category 23212
A Outcome0000
A Sub outcome 10000
A Sub outcome 20000
A Resigns0000
A sub outcomes0000
A Sub outcomes 20000
B Resigns0000
Migrations0000
     
Presentation AHT (seconds)420286296326
     
Allocated Hours80808080
Allocated FTE10.010.010.010.0
In Office Hours64566464
In Office FTE8.07.08.08.0
     
Equivalent Dials per Agent per Day34373941
Contacts per Agent per Day12131214
Presentations per Agent per Day89810
B Acquisitions per Agent per Day0.60.10.40.3
A Acquisitions per Agent per Day0.40.60.40.4
B Acquisition Conversion %8%1%5%3%
A Acquisition Conversion %5%7%5%4%
1 ACCEPTED SOLUTION
kcantor
Community Champion
Community Champion

@tylerdv

@MarcelBeugis correct.  You will need to transpose the information in PowerQuery. Thankfully, you only have to do it once and it will continue to run.

Check out this video for a tutorial:

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-5-cleaning-irregular-data/





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

Proud to be a Super User!




View solution in original post

4 REPLIES 4
kcantor
Community Champion
Community Champion

@tylerdv

@MarcelBeugis correct.  You will need to transpose the information in PowerQuery. Thankfully, you only have to do it once and it will continue to run.

Check out this video for a tutorial:

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-5-cleaning-irregular-data/





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

Proud to be a Super User!




Thanks! @kcantor & @MarcelBeug very helpful

 

I am assuming that as i add data to my sheet, and then hit refresh it will transpose and pull it through automatically?

The transpose as such will go fine if data is added.

 

However, if you have additional steps that refer to columns in the transposed table, these will go wrong in case those columns are no longer there after refresh.

 

One more remark to be complete: Table.Transpose has an optional second parameter in which you can define columns of the table after the transpose. In the code that is generated, this second parameter is left empty and if you keep it that way, you are good to go.

Specializing in Power Query Formula Language (M)
MarcelBeug
Community Champion
Community Champion

In the Query Editor - tab Transform - Transpose

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.