How to copy values

[Lora_0121]

Hello,

Is there a way to copy values to the clipboard while preserving the table format or export them to Excel?

I am attaching an example image.

⬇

[anilelmastasi · Accepted solution]

Hello @Lora_0121 ,

Could you please publish to Service and export data?

In PBI Desktop it exports like that.

[suparnababu8 · Accepted solution]

Hello @Lora_0121 

It's not possible from Power BI Desktop file. Please refere the below comment which was available in Microsoft Power BI documentation. URL - https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d... 

But you can export it as-is from Power BI services. Please follow below steps.

Step1: Let's say the following matrix data you want to export it from matrix chart.

Step2: Click on ... of matrix chart and click on export data

Step3: Then it will ask the prompt like below. Select Data Export with Current Layout and Click on Export.

Step 5:  Now if you see the below, preserved format of table data saved in csv files as-is.

I hope now you are clear.

Thank you!

Did I answer your question? Mark my post as a solution!
                                                                                                     
Proud to be a Super User!

[bhanu_gautam]

@Lora_0121 , Click on 3 dot above visual and check for export to excel

[Lora_0121]

@bhanu_gautam 

The format is not preserved. Instead of the pivot format, it is exported in a column-wise layout.

[anilelmastasi · Accepted solution]

Hello @Lora_0121 ,

Could you please publish to Service and export data?

In PBI Desktop it exports like that.