Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • JarroVGIT's avatar
    6 years ago

    Anonymous: 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.

    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.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 🙂