Forum Discussion
Merged cell in a power bi Table/Matrix
Hi, I am in need to display this table in Power BI, and I can't figure out how to put that big cell with the date on top of the rest. THX!
Can't use card, because the table will be way bigger with the options to scroll to the right
Hi Anonymous
This should be very possible out of the box
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
8 Replies
- AnkitaaMishra
Super User
Hi Anonymous ,
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
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
- MFelix
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.
- danextian
Hi Anonymous
This should be very possible out of the box
Hi Anonymous ,
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
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
Hi Anonymous ,
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
