Forum Discussion
Request for Guidance on Power BI Visualization
- 1 year ago
The visual you shared is based on merged cells, which is possible in Excel because Excel works at the cell level.
In Power BI, the design logic is different. The Matrix visual is built on rows and columns, and does not support true cell merging or centering. You can approximate the structure by:
-
Building a hierarchical table to align headers, and
-
Using dynamic measures or field parameters to control the values.
However, the result will not look exactly like Excel, and dynamic measures may also add performance overhead.
If you need the same look and flexibility, I recommend exploring third-party visuals such as Inforiver, which provide much greater control over table layouts (including merged headers). Their support team can also advise on your exact scenario.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Dear Ritaf1983
Thank you for your suggestion. I will try the solution as you recommended.
Dear Shivu-2000
If you don’t mind, could you please share a sample PBIX file so that I can implement it accordingly?