Forum Discussion
Helper IVPower BI Matrix Download as table format published on Fabric Service
Hi anusha_2023,
Thank you for reaching out to Microsoft Fabric Community.
Have you tried the approach shared by rohit1991 ?
By default, the Matrix visual groups row headers and doesn’t repeat values for each group.
This can be achieved by flattening the data or creating a custom table format using DAX and Table Visual.
By following this approach it ensures repeated row values for each product category while maintaining the dynamic nature of the data. r let us know if you need any further assistance if the issue still persists.
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!
Thanks and regards,
Anjan Kumar Chippa
Super UserHi anusha_2023 - Power BI's Matrix visual is hierarchical by nature, and turning off stepped layout will generally meet your needs.This will force the Matrix to repeat row headers for each level instead of grouping them.
To achieve the desired result of repeating row values (e.g., CustomerGroupName and CustomerName) for each ProductCategory in a Matrix visual in Power BI, while keeping the Year-Month data in the columns.
Let me know , I hope this solve the issue.
Helper IVThank you very much. I worked like golden approach. I did the same and the matrix format is formatted as table which fits perfect for Excel download.
But after downloaded as Excel fom the published report still format is different with Column headers and first Column "Customer" is still in hierarchy mode. But the good thing is with two work arounds we can perfectly reformat as table. Still Business people will not be happy for Excel reformatting for each download unfortunately.
Is this the way we are supposed to handover or am i doing anything wrong. Thank you very much for the help.