Forum Discussion
How to format card
Dear all.
I have a dynamic sentense want to show in power BI. The sentense is long and may need three lines. Can I make the card automatic change the line for me? Can I fix the length of each line to make it the same with other sentence in my paragraph? Thank you
3 Replies
Hi xiumi_hou ,
You could count the number of characters in the sentence after it has been created, create measures that take some portion of it, and put it into a multiline card. Or enter a carriage return every so many characters.Try using UNICHAR(10). For example: Column = "Line 1"& UNICHAR(10) & "Line 2".
And make sure you have the "Word Wrap" option activate on your Card/Table/Matrix/etc.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi Nathaniel_C ,
Thanks for answering. Please see below result. I used unichar( ) function.
How can I adjust the second line character and let it start from the beginging? Thanks
Hi xiumi_hou ,
I guess you will have find some unicode that will left format it. I don't know the answer, however here are two blogs and you may have to google or search for more. https://exceleratorbi.com.au/dax-unichar-function-power-bi/
https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/
or repost your question as a unicode inquiry to format your sentences left.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
