Forum Discussion

RLSid17's avatar
RLSid17
Helper III
3 years ago
Solved

Matrix Visual Export to Excel Columns

Hi, I have a Matrix visual that I would like to export the data with the same look as the visual: But when I exported it, it does not look like the ones from the visual where there ...
Need Help
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    3 years ago

    HI RLSid17 ,

     

    No you can't as this shows the calculation you are trying to represent on the matrix visual.

    One thing you can do is rename to a sensible name like Grouped Response rather than First Grouped Response in your matrix visual. This needs to be done in PBI Desktop and then publish report again to PBI service to export the matrix data.

     

RLSid17's avatar
RLSid17
Helper III
3 years ago

Thanks! This works but I have one query, would it be possible to remove the columns (highlighted in yellow) as I'm aiming it to be as simple as possible for reporting purposes:

 

Pragati11's avatar
Pragati11
Super User
3 years ago

HI RLSid17 ,

 

No you can't as this shows the calculation you are trying to represent on the matrix visual.

One thing you can do is rename to a sensible name like Grouped Response rather than First Grouped Response in your matrix visual. This needs to be done in PBI Desktop and then publish report again to PBI service to export the matrix data.

 

  • RLSid17's avatar
    RLSid17
    Helper III
    3 years ago

    Thank you so much for the quick response! Initially, I was trying to export using the summarized data but never though to use Data with current layout.

    • Pragati11's avatar
      Pragati11
      Super User
      3 years ago

      Hi RLSid17 ,

       

      I am glad that my suggestion helped here. 🙂