Forum Discussion
Copy row selection in matrix visual and maintain data structure as show in visual
Use case is to be able to copy a selected row in a matrix and maintain that fat row strucutre when pasted to clipboard. Out of the box a user can click on a row in a Matrix visual and copy the selected row. That's great.
When it is pasted from the clipboard it reverts back to the same csv format that one would get by exporting the data from the ellipse. See below
Unit_Name ForecastHour ForecastValue
ExampleUnit 8/7/2020 12:00:00 AM 0.00
ExampleUnit 8/7/2020 1:00:00 AM 0.00
ExampleUnit 8/7/2020 2:00:00 AM 0.00
ExampleUnit 8/7/2020 3:00:00 AM 0.00
ExampleUnit 8/7/2020 4:00:00 AM 0.00
ExampleUnit 8/7/2020 5:00:00 AM 0.00
ExampleUnit 8/7/2020 6:00:00 AM 0.00
ExampleUnit 8/7/2020 7:00:00 AM 0.00
ExampleUnit 8/7/2020 8:00:00 AM 3.00
ExampleUnit 8/7/2020 9:00:00 AM 15.00
ExampleUnit 8/7/2020 10:00:00 AM 28.00
ExampleUnit 8/7/2020 11:00:00 AM 29.00
ExampleUnit 8/7/2020 12:00:00 PM 29.00
ExampleUnit 8/7/2020 1:00:00 PM 29.00
ExampleUnit 8/7/2020 2:00:00 PM 28.00
ExampleUnit 8/7/2020 3:00:00 PM 28.00
ExampleUnit 8/7/2020 4:00:00 PM 28.00
ExampleUnit 8/7/2020 5:00:00 PM 27.00
ExampleUnit 8/7/2020 6:00:00 PM 26.00
ExampleUnit 8/7/2020 7:00:00 PM 21.00
ExampleUnit 8/7/2020 8:00:00 PM 8.00
ExampleUnit 8/7/2020 9:00:00 PM 2.00
ExampleUnit 8/7/2020 10:00:00 PM 0.00
ExampleUnit 8/7/2020 11:00:00 PM 0.00
Any ideas on how to maintain the "transposed" matrix structure into the clipboard as shown below? (Without the wrap caused by the table column size.)
| ForecastHour | 8/7/2020 0:00 | 8/7/2020 1:00 | 8/7/2020 2:00 | 8/7/2020 3:00 | 8/7/2020 4:00 | 8/7/2020 5:00 | etc |
| ForecastValue | 0 | 0 | 0 | 0 | 0 | 0 | etc |
Work-around currently is to paste into Excel, copy columns and then Paste Special with transpose. Thanks.
2 Replies
jmg80525 unfortunately you cannot copy the data in a similar format what is in matrix. Vote for this idea on ideas forum.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
HI jmg80525,
Unfortunately, export and copy features only get the raw records, you can't keep original data structures. Perhaps you can do some transform on these records or submit an idea for keeping the current dataset to export.
Regards,
Xiaoxin Sheng
