Forum Discussion
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 ...
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.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sonashish , export to excel is data export. The format will not export. Please log an idea https://ideas.powerbi.com/ideas/
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)?