Forum Discussion
Merged cell in a power bi Table/Matrix
- Anonymous1 year ago
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
Hi MDR03 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
B Manikanteswara Reddy