Display sharepoint data in different format and export as Visual

[Sonashish]

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 to export these two table as it is if possible with formatting. Please guide how can I generate two tables in same way as mentioned below.

However I am able to generate the requirement 1 table, but when I export to excel it is not exporting as it is and formatting is also loosing.  This is just sample data, In source table we have 100+ rows.

[V-lianl-msft · Accepted solution]

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.

[amitchandak]

@Sonashish , export to excel is data export. The format will not export. Please log an idea https://ideas.powerbi.com/ideas/

[Sonashish]

Hello Amit,

Thanks for reply. I will log an idea, however this idea is already logged.

Can you please help to create 2nd table (Requirement 2)?