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
Solved! Go to Solution.
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...3. You can use any seprator to seprate given columns i.e
Hope you will get this...
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
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.
@smjzahid , Not very clear. If you want to measure up and parameter up. I doubt that.
Refer if this can help
I doubt more flexibility then cover in these topics
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.