Forum Discussion
Merged cell in a power bi Table/Matrix
- 1 year ago
Hi Anonymous
This should be very possible out of the box
- Anonymous1 year ago
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community Forum.
danextian MFelix AnkitaaMishra Thank you for your quick response.
After reviewing the structure and requirements, it seems that replicating the exact layout as shown in your Excel screenshot is currently not directly achievable in Power BI, due to some limitations in matrix and table visuals, particularly around dynamic multi-row headers and aligning different metrics horizontally under date groupings.
However, we can achieve a similar layout using the Matrix visual, with dates as columns and metrics (e.g., Output Shift 1, Eficienta Shift 1, etc.) as values grouped under those dates. But please note, the data will be shown in aggregated form (like sum) rather than in a row-by-row flat structure as in Excel.
If this layout is critical for your reporting needs, I would recommend submitting a feature request on the Power BI Ideas forum, or reaching out via a support ticket to Microsoft for potential workarounds or roadmap considerations.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi Anonymous ,
If you are using a matrix then you just need to add the date column to the Columns on the table that will give you that hierarchy that you are looking for, since the measures/values will be placed below the columns on the matrix.