Error defining dynamic title on line & stacked column chart with same measure

[10246532]

I'm defining dynamic titles based on measures

It works fine on several visual types, but it fails with the error

"An error occured when rendering the report"

when applied to "line & stacked column chart" using the same measure for line and stacked column.

It work fine when I use diferent measures for line and stacked column.

I'm using PBI Desktop Version: 2.105.923.0 64-bit (may 2022)

[Anonymous]

Hi @10246532 ,

There are a few limitations to the current implementation of expression-based titles for visuals:

• Expression-based formatting isn’t currently supported on Python visuals, R visuals, or the Key Influencers visual.
• The field you create for the title must be a string data type. Measures that return numbers or date/time (or any other data type) aren't currently supported.
• Expression based titles aren't carried over when you pin a visual to a dashboard.
• Conditional formatting can only use measures defined in the underlying model, and cannot use measures locally created in a report (dataset connection).

Please troubleshoot against known limitations to ensure they are not the cause.

Best Regards,
Community Support Team _ Caitlyn

[10246532]

I define a very simple use case;

• the model is local and the tables are created with "enter data"
• the measure's datatype is text (it is a simple string)
• I'm working on desktop, no pinning to dashboard
• I'm using only standard visuals: "line and stacked column chart"
• dynamic title apply correctly when I apply one measure to "Column y-axis" and a different measure to "Line y-Axis"
• dynamic title abort with a run-time error when I apply the same measure to "Column y-axis" and "Line y-Axis"

Thanks

best regards

Luigi

[amartin141]

I had no problems returning a whole number to a dynamic title in an area chart (june 2022 version desktop, imported data).  It simply does not work in a stacked bar/line chart when the stacked bars are broken out by another measure.  Even when a static string was returned in the measure used.

[agusmba]

I encountered the same issue today.

All my pie, doughnut, bar charts use a dynamic title without problems, but the "line and stacked column chart" chokes on the same dynamic title.

Like Luigi said:

• dynamic title abort with a run-time error when I apply the same measure to "Column y-axis" and "Line y-Axis"

I'm using the same measure on column y-axis and Line y-Axis as a way of showing the total value for each column.

[agusmba]

So @10246532 's comments gave me a hit for a silly workaround.

I just defined another measure referencing the one I'm using twice on the line&column chart

---

New Duplicate Measure = [Original Measure]

Then I switched the line measure on the chart to the duplicated one.

Now the dynamic title works