Again, Please attach a workbook so that someone would help u faster.
Hi Deepak, thank you for the suggestion.
I have now added a workbook with an example textbox with formatted text.
I was able to make a word bold in between by splitting every line into Shapes and Colours.
Get Shape Only --->MID([Sentences],5, [Where is IS]-5 )
Get Colours Only ---->MID([Sentences],[Where is IS] +2,10)
That helped me to make a particular string bold as well (as shown above ) but I could not make all the different colours for different lines.
Not sure if that is possible. Please find the attached sheet
Book1_example.twbx 2.5 MB
In order to do this, the words in bold will have to become fields either in the data or calculated. I would just write a calculated field. I would put a MAX() around them so they are seen as measures. Put each on a sheet of its own and be sure to create your tooltip. When building your dashboard you will want to be sure to use containers rather than floating so the locations are not unexpectedly moved by a change in resolution.