Forum Discussion

Guillaume_R's avatar
Guillaume_R
Frequent Visitor
9 years ago

How to create a bulleted dynamic text in Power BI?

Hello,

 

In my dashboard I want to include a dynamic text area in function of the value selected in the slicer. Until now, no problem to build a dynamic text area depending on the value in the slicer.

However, I do not want a simple dynamic text area. I want to get a structured dynamic text area with bullet points and different levels: Heading, Title1, Title2, ...

 

I could not find anything on the subject.

Does anyone have a solution?

 

Thanks for your help.

7 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Guillaume_R

     

    What's the visual are you using for dynamic text area currently? 

     

    If you only need to show the text with entire hierarchy, you can try Hierarchy Slicer. 

     

    If you also need to show fact data, you can use Matrix visual so that you can drill down to child level. 

     

    Regards,

     

    • Guillaume_R's avatar
      Guillaume_R
      Frequent Visitor
      9 years ago

      Hi Simon,

       

      I use visualization called "Card", when you use it the text is not structured, i lost all the structure/list with bullets.

      In fact, i want to have a comment box where you can use bullet, put titles in bold, ... and this box has to be updated when I change the value in the slicer.

      For me hierarchy slicer does not work with what i want.

      Someone mentionned to me to look at if i could use Markdown or HTML to do that... Do you know if it is possible?

      thanks

      Regards

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi there,

     

    Were you able to find a solution to your question? I'm having the same issue and was wondering if you can assist with some hints or update the post if you got it to work? 

     

    Thanks!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous, do you have an answer to this one? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I think you want a dynamic text measure.  (Yes you'll need to create a measure to do this using HASONEVALUE function.)

         

        There is a lot of information on HASONEVALUE in the community.  

         

        See this video @ 28 min. mark. 

  • robonuj's avatar
    robonuj
    Frequent Visitor
    2 years ago

    The HTML Content visualization might help you.

  • Belin's avatar
    Belin
    Frequent Visitor
    1 year ago

    Here is what I did:

    I have created a matrix visual and removed the title and all the lines, then I have displayed the measure below and covered teh matrix with a transparent shape (so nobody can trigger the interactions of the matrix), which return this format:

     

    - Test_table[Column1]

    - Test_table[Column2]

    - Test_table[Column3]

       Test_table[Column4]

          - Test_table[Column5] - Test_table[Column6]

          - Test_table[Column5] - Test_table[Column6]

          - Test_table[Column5] - Test_table[Column6]

     

     

     

    Comments_FD =
    VAR _comment1 = VALUES(Test_table[Column1])
    VAR _comment2 = VALUES(Test_table[Column2])
    VAR _comment3 = VALUES(Test_table[Column3])
    VAR _text = VALUES(Test_table[Column4])
    VAR _ci1 = VALUES(Test_table[Column5])
    VAR _ci_comment1 = VALUES(Test_table[Column6])
    VAR _ci2 = VALUES(Test_table[Column7])
    VAR _ci_comment2 = VALUES(Test_table[Column8])
    VAR _ci3 = VALUES(Test_table[Column9])
    VAR _ci_comment3 = VALUES(Test_table[Column10])

    RETURN
    UNICHAR(8226) & " " & _comment1 & UNICHAR(10) & UNICHAR(10) &
    UNICHAR(8226) & " " & _comment2 & UNICHAR(10) & UNICHAR(10) &
    UNICHAR(8226) & " " & _comment3 & UNICHAR(10) & UNICHAR(10) &
    _text & UNICHAR(10) &
    "   " & UNICHAR(8226) & " " & _ci1 & " - " & _ci_comment1 & UNICHAR(10) & UNICHAR(10) &
    "   " & UNICHAR(8226) & " " & _ci2 & " - " & _ci_comment2 & UNICHAR(10) & UNICHAR(10) &
    "   " & UNICHAR(8226) & " " & _ci3 & " - " & _ci_comment3