Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix Export to Excel Formatting Column Headers

When I export my matrix visual to excel and keep the same format, the column header and the name of the value appear in the excel output. Here is an example of how my report looks in pbi:

and here is an example of how my report looks in excel:

Is there a way to remove this "revenue" header from all the value columns?

 

 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    For those wondering, I solved this by pivoting the original dataset and creating a table visual instead of a matrix 

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous 
    It is unfortunately impossible to influence the display of data when exporting it to Excel.
    Only a summarized table can be exported, but then you lose the structure's advantage.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    For those wondering, I solved this by pivoting the original dataset and creating a table visual instead of a matrix