HR Consultation Insights - Power BI Challenge #3 Entry from Greg

[Greg]

Hi @AoakeP

Thanks for your kind words. I’m humbled you found the solution interesting.

Even easier, you can do this without a custom visual using CONCATENATE in a card as @BrianJ describes in this thread:

Including a DAX Measure in a text field

@llchoong, Here’s one way to do this using nested CONCATENATE functions (since you can only concatenate two text strings at a time): Example Label = VAR FirstString = CONCATENATE( "This measure is the concatenation of text plus the value of another measure, ", [Count Closed Claims] ) RETURN CONCATENATE( FirstString, ", with more text." ) [image] Interestingly, when I put this example together I found there was more formatting flexibility in using a table visual that card visu…

or perhaps COMBINEVALUES in a table cell, something like:

Long Dynamic Text with Measures = 
VAR _Separator = UNICHAR(10) & UNICHAR(10)
VAR _Sentence1 = "This is the first sentence that contains the value from the [Total Sales] measure as " & FORMAT( [Total Sales], "Currency" ) & "."
VAR _Sentence2 = "This is the second sentence that contains the value from the [Total Costs] measure as " & FORMAT( [Total Costs], "Currency" ) & "."
VAR _Sentence3 = "This is the third sentence that contains the value from the [Total Profits] measure as " & FORMAT( [Total Profits], "Currency" ) & "."

RETURN
COMBINEVALUES( _Separator, _Sentence1, _Sentence2, _Sentence3, _Sentence1, _Sentence2, _Sentence3, _Sentence1, _Sentence2, _Sentence3 )

(In these last 2, you lose the independent sizing but gain “story” length.)

Greg