Forum Discussion
Dynamic Insightful Ttitle
Yes, this is doable natively in Power BI without any add-on.
The trick is to build a DAX measure that returns the sentence you want, then bind it to the visual title. Click the title area, open Format visual, expand Title, click the fx icon next to Text, set Format style to "Field value", and pick your measure. The title now updates as the underlying data shifts.
A quick pattern for a top-mover title:
Insight Title = VAR Top1 = TOPN(1, VALUES(Client[Name]), [Sales Change %], DESC) VAR ClientName = CONCATENATEX(Top1, Client[Name]) VAR Pct = FORMAT([Sales Change %], "+0.0%;-0.0%") RETURN ClientName & " changed by " & Pct & " vs last period"
If you want the narrative generated for you instead of hand-coded, drop the built-in Smart Narrative visual on the page. It produces plain-English commentary about the visuals it can reach, which is very close to that concise insight feel you described.
If this helped, a thumbs up and marking it as the accepted solution would be appreciated.
Best regards,
Shai Karmani
Yes, this is doable natively in Power BI without any add-on.
The trick is to build a DAX measure that returns the sentence you want, then bind it to the visual title. Click the title area, open Format visual, expand Title, click the fx icon next to Text, set Format style to "Field value", and pick your measure. The title now updates as the underlying data shifts.
A quick pattern for a top-mover title:
Insight Title = VAR Top1 = TOPN(1, VALUES(Client[Name]), [Sales Change %], DESC) VAR ClientName = CONCATENATEX(Top1, Client[Name]) VAR Pct = FORMAT([Sales Change %], "+0.0%;-0.0%") RETURN ClientName & " changed by " & Pct & " vs last period"
If you want the narrative generated for you instead of hand-coded, drop the built-in Smart Narrative visual on the page. It produces plain-English commentary about the visuals it can reach, which is very close to that concise insight feel you described.
If this helped, a thumbs up and marking it as the accepted solution would be appreciated.
Best regards,
Shai Karmani
Shai_Karmani Thank You Very Much
I dont have control of the smart visual to provide a concise one liner for sub title as at the end of page i want to place copliot narrative visual, this is better i need to just determine the purpose of the visual to base my text