Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jmackeyiii
Frequent Visitor

highlighting and copying text in power bi

Is there a way to have a visual that displays data in a manner that a user can highlight the value and drag and drop it to word or another application.  This is available in web pages and most other MS applications.  having the user right click and then navigate down to the second level of a popup menu is not an acceptable answer the least acceptable answer is the user can highlight and press Ctl+C or right click and chose copy.

 

No ones seems to want this or is able to answer others when they have asked.

1 ACCEPTED SOLUTION

Alison,

 

Thank you for your attention.  I believe this is the place for this question, for this reason.  When searching for a solution I have come across other users that asked the same thing all received similar answers.  This being 2 years since one of the questions was asked and still there is no BI out of the box add-in/ approved solution for this, that means there requesting of this hasn't happened or its popularity has not been enough to garner development of a market place level idea.  I did know that the solution existed because some people would hint around it and there are some amazing html and dax solutions out there that are mind blowing.  I don't need mind blowing. This is what I needed(ex. two boxes one with css the other without):

 

1) Create a Measure - 

HTML_Data =
"<html>"
& "<head>"
& " <style type=""text/css""> "
& " .tbox{"
& "border:2px solid #b3b3b3;"
& "background:#dddddd;"
& "width:300px;"
& "border-radius:25px;"
& "-moz-border-radius:25px; "
& "-moz-box-shadow: 1px 1px 1px #ccc;"
& "-webkit-box-shadow: 1px 1px 1px 1px #ccc;"
& " box-shadow: 1px 2px 2px 2px #ccc;}"
& "</style>"
& "</head><body><div><p>this can be whatever text you want</p></div>"
& "<input type=""text"" class=""tbox"" value=""" & MeasureTbl[DriverCard] & """ id=""Driver""/>"
& "<input type=""text"" class=""tbox"" value=""" & MeasureTbl[ThatEquals53] & """ id=""Driver""/>"
& "<div><input type=""text"" width=""500"" value=""" & MeasureTbl[DriverCard] & """ id=""Driver""></div>"
& "</body></html>"
 

2) Using the Html Content visual on your dashboard assign it this html_body(or whatever you have named it) measure in the values of the visual. No granularity.  Switch out "MeasureTbl[DriverCard]" with your table and measure or column.

 

Result:

jmackeyiii_2-1644857181493.png

 

 

ability to select and ctl+'C' and drag and drop from windows/applications.

jmackeyiii_3-1644857193352.png

 

 

This is the solution, as the BI visual functionality scope does not exactly align with the ability to do this there is not a huge demand.  Since I know there are at least two others out there want this simple solution I am posting what I resolved to use.  This is as simple as it gets for accomplishing my task but as I have seen with others expounding on dax funcitonality the other things that can be are insane.

 

Thank you again for taking your time out to assist me.

View solution in original post

4 REPLIES 4
AllisonKennedy
Super User
Super User

@jmackeyiii  You can export the entire visual to Excel, jpg or PowerPoint. If you'd like to copy data labels, vote for the idea in Power BI ideas: https://ideas.powerbi.com/ideas/

 

They do actually listen to those, so post your link here to gain more votes.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy I appreciate you providing me with the possible solution.  It is not what I am looking for.

 

"You can export the " at this moment your idea is not the way I want to go or asked.

 

jmackeyiii_0-1644584158529.png

 

I higlighted that from your post above left clicked it and dragged it down into this reply.  This is what I want my User to do.  I don't want 3 levels of popups 3 different applications to open and then them have to press ctrl+C and then ctrl+V.  

 

in this image i did the same thing from this post to another browser window:

jmackeyiii_2-1644584822811.png

 

I have gone through a good bit of add-ins trying to find this simple solution.  I have noticed a few other people have asked this and essentially they were given similar and even less sophisticated answers.  This is a very simple windows and office task capability that many have taken for granted I believe.  The rendering of graphics within BI and the browser along with the add-ins have made this small thing an oversight.

 

I would like to thank you again, I just need a different solution that meets my users needs.

 

@jmackeyiii  I totally get what you're saying, but this is not the right place to post your ideas. The Power BI engineers look at  https://ideas.powerbi.com/ideas/ and go for the most voted ideas for further development. Post an idea there, then come back here and share the link so you can get more votes for it. 

 

Good luck!


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Alison,

 

Thank you for your attention.  I believe this is the place for this question, for this reason.  When searching for a solution I have come across other users that asked the same thing all received similar answers.  This being 2 years since one of the questions was asked and still there is no BI out of the box add-in/ approved solution for this, that means there requesting of this hasn't happened or its popularity has not been enough to garner development of a market place level idea.  I did know that the solution existed because some people would hint around it and there are some amazing html and dax solutions out there that are mind blowing.  I don't need mind blowing. This is what I needed(ex. two boxes one with css the other without):

 

1) Create a Measure - 

HTML_Data =
"<html>"
& "<head>"
& " <style type=""text/css""> "
& " .tbox{"
& "border:2px solid #b3b3b3;"
& "background:#dddddd;"
& "width:300px;"
& "border-radius:25px;"
& "-moz-border-radius:25px; "
& "-moz-box-shadow: 1px 1px 1px #ccc;"
& "-webkit-box-shadow: 1px 1px 1px 1px #ccc;"
& " box-shadow: 1px 2px 2px 2px #ccc;}"
& "</style>"
& "</head><body><div><p>this can be whatever text you want</p></div>"
& "<input type=""text"" class=""tbox"" value=""" & MeasureTbl[DriverCard] & """ id=""Driver""/>"
& "<input type=""text"" class=""tbox"" value=""" & MeasureTbl[ThatEquals53] & """ id=""Driver""/>"
& "<div><input type=""text"" width=""500"" value=""" & MeasureTbl[DriverCard] & """ id=""Driver""></div>"
& "</body></html>"
 

2) Using the Html Content visual on your dashboard assign it this html_body(or whatever you have named it) measure in the values of the visual. No granularity.  Switch out "MeasureTbl[DriverCard]" with your table and measure or column.

 

Result:

jmackeyiii_2-1644857181493.png

 

 

ability to select and ctl+'C' and drag and drop from windows/applications.

jmackeyiii_3-1644857193352.png

 

 

This is the solution, as the BI visual functionality scope does not exactly align with the ability to do this there is not a huge demand.  Since I know there are at least two others out there want this simple solution I am posting what I resolved to use.  This is as simple as it gets for accomplishing my task but as I have seen with others expounding on dax funcitonality the other things that can be are insane.

 

Thank you again for taking your time out to assist me.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.