Forum Discussion

Sonashish's avatar
Sonashish
Resolver I
5 years ago
Solved

Display sharepoint data in different format and export as Visual

Hello  I pulled the data from SharePoint see left side table. Using this data I want to present data in two different table as displayed in right side (requirement 1 and requirement 2). I also want ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Sonashish ,

     

    Based on your description, you may be creating a matrix visual that leads to the export of unformatted data.

    You can try to copy the table in the query editor, and then do pivot operation on the table.

    Create a relationship between the duplicate table and the fact table, and use the table visual to display.

    Sample .pbix

     

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

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Sonashish ,

 

Based on your description, you may be creating a matrix visual that leads to the export of unformatted data.

You can try to copy the table in the query editor, and then do pivot operation on the table.

Create a relationship between the duplicate table and the fact table, and use the table visual to display.

Sample .pbix

 

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