How to create a bulleted dynamic text in Power BI?

[Guillaume_R]

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.

[Belin]

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

[robonuj]

The HTML Content visualization might help you.

[Anonymous]

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]

@Anonymous, do you have an answer to this one? 

[Anonymous]

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. 

[v-sihou-msft]

@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]

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