I want Export data of matrix visual in matrix form not in tabular form.
I am using matix visual, with fields ( Row = Member name, column = Date and value = Spent hours ) and i am getting the data in matrix format perfectly (in power BI desktop/ services). But when I export the same to excel, I get it in tabular form. Is it possible to get the excel file in the same format as showing in power bi desktop/services( matrix form).
Ultimately, this is a feature miss that Microsoft tried to stopgap with bolting on SSRS to Power BI in the form of paginated reports, and the workarounds are ugly and scary. It could be an opportunity to productize a hacky solution, but honestly I think that Microsoft needs to address this one, and I'll beat the drum for that.
There are many custom visuals that other companies have created. I honestly cannot believe that neither Microsoft nor any other company have created a version of the matrix visual that can export to Excel while retaining the row hierarchy levels and column groups, as SSRS does.