Hi All,
I need "Invoicedate" to be displayed in columns.
How to achieve this?
Should be displayed like this,
Regards,
Manivannan M
Solved! Go to Solution.
usually it is the other direction! - go to query editor - you'll see a section in the ribbon for transform, pivot, etc - there are also a bunch of good tutorial videos around showiing examples....
check out at YouTube for Enterprise DNA New Zealand has a video named Advanced Transformations
Hi @Manivannan,
I think pivot column feature will be suitable for your requirement, you can refer to below article to know more about this.
The New Pivot Column option in Power Query
Regards,
Xiaoxin Sheng
If you don't want to change your dataset structure, this can be easily done in Matrix table visual. Just drag the Invoice Date into the Columns as circled in the pic.
Cheers
Myra Ma
If you don't want to change your dataset structure, this can be easily done in Matrix table visual. Just drag the Invoice Date into the Columns as circled in the pic.
Cheers
Myra Ma
@MyraMainput really is preferable - - you should typically not de-normalize your data set.....
Hi @Manivannan,
I think pivot column feature will be suitable for your requirement, you can refer to below article to know more about this.
The New Pivot Column option in Power Query
Regards,
Xiaoxin Sheng
usually it is the other direction! - go to query editor - you'll see a section in the ribbon for transform, pivot, etc - there are also a bunch of good tutorial videos around showiing examples....
check out at YouTube for Enterprise DNA New Zealand has a video named Advanced Transformations
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
461 | |
178 | |
117 | |
62 | |
51 |
User | Count |
---|---|
444 | |
162 | |
129 | |
76 | |
73 |