Forum Discussion
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 slic...
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