Forum Discussion
Merged cell in a power bi Table/Matrix
Hi MDR03 ,
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
Super UserHi MDR03 ,
If you use matrix visual, you will be able to achieve this look and you need to add the date in columns and all the measure in values field as shown below & then format the column headers to center align from format visual tab:
Thanks,
Ankita
How should the table in excel be structured to be able to do that?
Hi MDR03 ,
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