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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Manivannan
Helper I
Helper I

Convert Rows to columns

Hi All,

 

I need  "Invoicedate" to be displayed in columns.

How to achieve this?

 

 

 

Capture111.PNG

 

Should be displayed like this,

 

Capture123.PNG

 

 

Regards,

Manivannan M

3 ACCEPTED SOLUTIONS
CahabaData
Memorable Member
Memorable Member

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

 

 

www.CahabaData.com

View solution in original post

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

MyraMa
Advocate II
Advocate II

If you don't want to change your dataset structure, this can be easily done in Matrix table visual. Matrix.png Just drag the Invoice Date into the Columns as circled in the pic.

 

Cheers

Myra Ma

 

 

View solution in original post

4 REPLIES 4
MyraMa
Advocate II
Advocate II

If you don't want to change your dataset structure, this can be easily done in Matrix table visual. Matrix.png 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.....

 

 

www.CahabaData.com
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
CahabaData
Memorable Member
Memorable Member

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

 

 

www.CahabaData.com

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.