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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
smjzahid
Helper V
Helper V

How to use the Merge Cells for columns in Power BI

How do we merge the columns in Power BI, similar to how we do in excel. 

 

I know of a Matrix visual in power BI but didn't quite get the columns to merge. What I am looking at is shown in below snip

 

 
 
 

image.png

 

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to use matrix visual, see this:

3.PNG

See my attached pbix file.

 

Best Regards,

Giotto

View solution in original post

8 REPLIES 8
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to use matrix visual, see this:

3.PNG

See my attached pbix file.

 

Best Regards,

Giotto

Anonymous
Not applicable

This is Ok in a simple table but if have a measure calculate? can i use this?

Anonymous
Not applicable

Hi @smjzahid,

                 You can easily achive this in power bi by these steps...
1. Open Edit Queries and select  columns which you want to merge.
2. Go under  transform panel and select merge columns and you will get this window...Screenshot (39).png3. You can use any seprator to seprate given columns i.e 
Screenshot (41).png

 

Hope you will get this...
Thanks

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Hi @Anonymous 

Thanks for your reply, Not quite merging 2 or 3 columns. I am looking to display data in this fashion. I am looking probably somethinng on the visual side of it (Merge using Power Query wont achieve that) It will just combine columns, it wont display as I want it to display.

 

How I want to display is below. Note How Q3 is merged into one cell and the columns (Actual, Turnover, Margin%) they all come out from my table. I am just looking to provide a label on top of those 3 columns. I hope you now get what I am trying to explain.

 

image.png

 

 

amitchandak
Super User
Super User

@smjzahid , Not very clear. If you want to measure up and parameter up. I doubt that.

 

Refer if this can help

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

 

I doubt more flexibility then cover in these topics

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hi @amitchandak 

 

This is what I want. The link you provide does not show how to get this done. Note how Q3 is merged and then I can display 3 separate columns 

 

 

image.png

 

@smjzahid , somehow I see in grouped always

Matrix.png

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

Hi 
A  Jan Feb Mar
B      20%
in matrix of power bi i want merge Quarterly value of Jan,feb,Mar in single merge cell when i put quarterly measure

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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