Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Is there any way to merge more than 1 row in Power BI, like we have option to merge the cells in Excel. The requirement is to present the data in the attached format. Any quick help is really appreciable.
Regards,
Arushi
hi @Anonymous
For Values in matrix, it could not achieve that merge them as excel in power bi matrix visual for now,
you may submit an idea in here.
Regards,
Lin
Hi @Anonymous ,
Not sure if the usecase which you are trying will work in any Power BI Visual.
Here is what all you can try with a matrix.
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
20 tricks to finally master the Matrix visualization in Power BI!! --> https://www.youtube.com/watch?v=58a2rIV2nYg
See if any of these can help
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
HI @Anonymous
It is definatively not a possibility in Power BI.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous , You can not merge in the middle. only initial rows can be merged.
Refer
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
@Anonymous - Yeah, no. I don't know of any way to do that in Power BI matrix visual!
Hi @Anonymous
I think yes that is doable in PowerBI matrix table, when you turn off the stepped layout in the row header format setting.
In your pic 3rd columns showing bigger merge then second column, I think this will be a problem, probably you would require to change the row placement in your matrix table.
Let me know if above makes sense.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |