Forum Discussion

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
1 year ago
Solved

Power BI Matrix Download as table format published on Fabric Service

I have a request from user on several ocassions who need Matrix data in the form of table with repeated Row values for each group For example CustomerGroupName and Customer name need to be repeated f...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    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

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

To repeat row values in a Power BI Matrix and export as a table:

  1. Flatten with DAX: Create a calculated table using:

 

FlattenedTable = 
SUMMARIZE(
    TableName,
    TableName[CustomerGroupName],
    TableName[CustomerName],
    TableName[ProductCategory],
    TableName[YearMonth],
    "Value", [Measure]
)

 

 

  •  

  • Use Table Visual: Build a Table visual with the flattened table.

  • Export: Enable "Export Data" to allow downloads in CSV/Excel format.