Joining text with formatted headers

[Anonymous]

Hi, i have four text fields that i wish to show on a dashaboard. I could add them singly to cards, but this will potentially waste a lot of space as the fields will be of varying character length resulting in some fields not fitting and others having lots of white space. 

I wonder if it is possible to concatenate these fields and have a formatted header between each, e.g. something like the below:-

[dax · Accepted solution]

Hi NotDave, 

There is no visual for this format currently. One workaround is that you could try to use Card Browse (import this from powrbi market),   then modify your data to below(Eidt Query->choose four field->unpivot columns)

 Then use Card Browser like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dax · Accepted solution]

Hi NotDave, 

There is no visual for this format currently. One workaround is that you could try to use Card Browse (import this from powrbi market),   then modify your data to below(Eidt Query->choose four field->unpivot columns)

 Then use Card Browser like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, unfortunatelyt this is not what i am looking for. I am hoping to merge fields of varying length into one string and format the headers of each field to identify the separate fields that have been merged. The reason for this is to reduce the amoung ot white space in the report and to allow one long field to be merged with two shorter fields.

The solution - as i understand it - will have a similar amount of white space as 4 separate cards each pointed to an individual field.

Is there a way to construct and display HTML? E.g, taking the field headers and wrap in <h1> tags, the field text and wrap in <p> tags and concatenating all this together.

<h1>Field One Header</h1>
<p>Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text Field one text</p>
<h1>Field Two Header</h1>
<p>Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field Field two text longer text for this field</p>
<h1>Field Three Header</h1>
<p>Field three text shorter text for this field</p>

[Anonymous · Accepted solution]

Please see details in this post on how i have achieved the result. Note the linked post discusses what to do when a field is blank but discusses how to concatenate text and code to build HTML.

I also used the HTMLviewer visual

https://community.powerbi.com/t5/Desktop/If-blank-dax-statement/m-p/829816/thread-id/398653#M399056