Forum Discussion
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-Jan | 29-Jan | 29-Jan | 29-Jan | |
| 24-Jan | 25-Jan | 26-Jan | 27-Jan | |
| Total Dials | 338 | 369 | 391 | 409 |
| Total Decision Maker Contacts | 117 | 130 | 116 | 136 |
| Contact % | 35% | 35% | 30% | 33% |
| Total Presentations | 77 | 90 | 81 | 95 |
| Presentation Rate % | 66% | 69% | 70% | 70% |
| A Acquisitions | 6 | 1 | 4 | 3 |
| B Acquisitions | 4 | 6 | 4 | 4 |
| - B Acquisitions categroy 0 | 3 | 2 | 1 | 2 |
| - B Acquisitions category 1 | 0 | 0 | 0 | 0 |
| - B Acquisitions category 2 | 3 | 2 | 1 | 2 |
| A Outcome | 0 | 0 | 0 | 0 |
| A Sub outcome 1 | 0 | 0 | 0 | 0 |
| A Sub outcome 2 | 0 | 0 | 0 | 0 |
| A Resigns | 0 | 0 | 0 | 0 |
| A sub outcomes | 0 | 0 | 0 | 0 |
| A Sub outcomes 2 | 0 | 0 | 0 | 0 |
| B Resigns | 0 | 0 | 0 | 0 |
| Migrations | 0 | 0 | 0 | 0 |
| Presentation AHT (seconds) | 420 | 286 | 296 | 326 |
| Allocated Hours | 80 | 80 | 80 | 80 |
| Allocated FTE | 10.0 | 10.0 | 10.0 | 10.0 |
| In Office Hours | 64 | 56 | 64 | 64 |
| In Office FTE | 8.0 | 7.0 | 8.0 | 8.0 |
| Equivalent Dials per Agent per Day | 34 | 37 | 39 | 41 |
| Contacts per Agent per Day | 12 | 13 | 12 | 14 |
| Presentations per Agent per Day | 8 | 9 | 8 | 10 |
| B Acquisitions per Agent per Day | 0.6 | 0.1 | 0.4 | 0.3 |
| A Acquisitions per Agent per Day | 0.4 | 0.6 | 0.4 | 0.4 |
| B Acquisition Conversion % | 8% | 1% | 5% | 3% |
| A Acquisition Conversion % | 5% | 7% | 5% | 4% |
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/
4 Replies
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/
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.
In the Query Editor - tab Transform - Transpose
