cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to display long text or comments within the data

Dear Forum members,

 

I have searched google and found few answers but still not found what I am looking for.

I have a comment or a note column which has extremely long text literally minimum of 2-3 lines to max. 40-50 lines. These are plain text no html involved otherwise I would have used HTMLViewer custom visual.

 

What I would like to do is to simply display my data (other fields) in a table related to this note and once any row is clicked then a rich text box appears/show (should be hidden when no row is selected, only clicking on the table any row) on the side/bottom of the screen with the complete note/comment related to that row, Is this something doable in Power BI? if it is, would anyone directs me and if it is not possible in Power BI will there be any alternate solution to resolve this?

 

Please if anyone can kindly share their thoughts on this, Many thanks in advance.

 

Kind regards,

1 ACCEPTED SOLUTION
Resident Rockstar
Resident Rockstar

@PowerBISDK_COD: combining both the post of @parry2k and below will result in what you want! ( @parry2k : interesting link, learned something new today! 🙂 )

Well it isn't a rich text box but this is what I came up with. I have created an example with the following data:

Table4 containing multi-line text in Column1.Table4 containing multi-line text in Column1.

Then, I've created the following measure:

 

Measure = IF(HASONEVALUE(Table4[ID]), DISTINCT(Table4[Column1]))

 

This measure returns the Column1 value when the current data context has only 1 value in the ID column. Otherwise, it returns empty. 

Creating a table containing the ID column, and another table containing the Measure results in the follwing:

No row selected in the table with ID's, so the measure returns nothing.No row selected in the table with ID's, so the measure returns nothing.Row with ID = B selected, and table with measure returns the longtext.Row with ID = B selected, and table with measure returns the longtext.

With some mark up you can mimic the behaviour what you are looking for I think, but this will be the closest you will get. Try Card as visual for the Measure, that seems maybe might get you where you want to go 🙂

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Resident Rockstar
Resident Rockstar

@PowerBISDK_COD: combining both the post of @parry2k and below will result in what you want! ( @parry2k : interesting link, learned something new today! 🙂 )

Well it isn't a rich text box but this is what I came up with. I have created an example with the following data:

Table4 containing multi-line text in Column1.Table4 containing multi-line text in Column1.

Then, I've created the following measure:

 

Measure = IF(HASONEVALUE(Table4[ID]), DISTINCT(Table4[Column1]))

 

This measure returns the Column1 value when the current data context has only 1 value in the ID column. Otherwise, it returns empty. 

Creating a table containing the ID column, and another table containing the Measure results in the follwing:

No row selected in the table with ID's, so the measure returns nothing.No row selected in the table with ID's, so the measure returns nothing.Row with ID = B selected, and table with measure returns the longtext.Row with ID = B selected, and table with measure returns the longtext.

With some mark up you can mimic the behaviour what you are looking for I think, but this will be the closest you will get. Try Card as visual for the Measure, that seems maybe might get you where you want to go 🙂

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

@JarroVGIT 

Thank You very much, appreciated, I can see this is really the closest I can get but it works, great. 

 

Thank You so much.

 

Kind regards

Super User III
Super User III

@PowerBISDK_COD you can surely achieve this, in this post it is explain how this can be achieved and use the same method for your use case.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





One thing which really confuses me @parry2k - the article was published in April 2019 and I had a version of April 2019 for Power BI but I cannot see conditional formatting for a card which leads me to update the Power BI - November 2019.

 

I am confused how the author managed to see that? Were there 2 releases in April 2019, that is the only thing I can think of.

Hi @parry2k - great, thank You, I did find this and applied to show or hide my HTMLViewer - it seems to work fine but the only issue the conditional formatting introduced in Power BI November 2019 release for card - it was not there, I had a difficulty in order to replicate and finally realise this is only available in November 2019 release.

 

Appreciated Your help and support.

 

Kind regards,

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors