Ability to set Chart Title for a Line/Stacked Chart by a measure is now broken via Dec 2020 release

[dharsanj]

Hello,

Noticed something that is now caused by the Dec 2020 PowerBi release. Previously, one could set the title of a Line and Stacked Chart via a measure and get it to display. However, with the new release, the visual keeps spinning with a call to Direct Query which doesn't seem to end. 

If I convert this chart to a stacked bar chart (without the line), then the display appears instantaneously with no spinning around of the visual. 

The title I want to embed in the chart is via this measure definition:

Title =  CONCATENATE("Trended Value by Category", " ($M)" )

See snapshots below:

Line/Stacked Chart - this is the original visual with no titleChart Title MeasureSetting up the Chart TitleAfter inserting chart title, then visual spins no end. There is also a Direct Query callIf I convert to a stacked chart only (from Line/Stacked Chart), then the title shows up as it should.

[Anonymous]

Have you found a resolution to this? I having the same problem. We have a simple conditional formatting for title, and it does not work on the Line And Stacked Column Chart. It works on every other chart EXCEPT the one I need, which is Line And Stacked Column Chart. I've messed around with it, switching up and removing different fields with no solution. Just the loading wheel that keeps spinning. Not sure where to go from here, and hoping you were able to fix your issue.

[amartin141]

same problem here (june 2022 version)

[parry2k]

@dharsanj I can reproduce it, very weird and I would recommend to report it as an issue on the support page.

[dharsanj]

Here is the Power BI Desktop version I am using:

Version: 2.88.721.0 64-bit (December 2020)

[dharsanj]

Ok. I will try. The Total measure is defined as follows:

VAR OpMgn =

CALCULATE (

[WaterfallAmt (ABS)],

'TestWaterfallTbl'[PnL-Lvl 4] = "Operating Margin"

)

RETURN

IF (

ISFILTERED ( 'TestWaterfallTbl'[PnL-Lvl 3 (Stacked Chart)] )

|| ISFILTERED ( 'TestWaterfallTbl'[PnL-Lvl 4] )

|| ISFILTERED ( 'TestWaterfallTbl'[Alt PnL-Lvl 3] ),

[WaterfallAmt (ABS)],

OpMgn

)

[PhilipTreacy]

Hi @dharsanj 

I can't reproduce this. Using your measure I get the title displayed fine.

If you strip back the chart to just some simple values, will the Title Measure display?  Perhaps your Total measure is causing some issue?

regards

Phil

[dharsanj]

Ok. I have a very simple contrived example. Is there anyway I can attached the PowerBI file that I used? 

I just entered the following data table (named "Org"):

Data Table

Then two measures:

SalesAmt = SUM(Org[Sales])

Title = "Sales by Group"

Then I added 4 chart variations:

Variation 1 - Line and Stacked Chart with Measure Title. Chart Measure only in Column Values.

This works

So this one works since I didn't put the [SalesAmt] Measure in the Line Values box. Title is driven by Measure.

Variation 2 - Line and Stacked Chart with No Measure Title. Chart Measure in both Column and Line Values:

Line and Stacked Chart - No Title, but SalesAmt in both Column Values and Line Values

This one also works since I didn't put the Title measure in the chart. No title, but I get Stacked Chart and Line.

Variation 3 - Line and Stacked Chart with Measure Title, but Chart Measure only in the Line Values:

This one also works

In the absence of SalesAmt in Column values, this one also works with the Title measure in the chart. But I only get a Line in the visual since I didn't apply the [SalesAmt] in the Column values.

Variation 4 - Line and Stacked Chart with Measure Title [Title], with Chart Measure  [SalesAmt] in both Column and Line Values:

The previous problem now surfaces with the spinning visual, and display not appearing. See snapshots below:

Chart Display settingsChart Title setting

I do not know why this is happening for the line and stacked chart where I want to set the Title based on a Measure. Any advise? The Performance Analyzer shows a Direct Query in addition to the DAX query. Why is this happening? 

[dharsanj]

This is a simpliflied chart title measure to illustrate the issue. The one I originally had was dynamic based on filtered table selections, which were fields in the CONCATENATE string (as part of a SELECTEDVALUE(....)) invocation. 

Even the simple one seems to be causing a issue which needs to be understood. 

[dharsanj]

Also want to point out:

If I remove the measure that went into the Line values box, then the display appears with the chart title (with the Stacked Line/Chart as the visual selected). The issue is that I can't place the same measure in the Line values section.

[hdg]

Hi was wondering if you figured this out. I have the same issue when I put in the line/stacked bar chart it gives me a spinning title (my title is a derived measure), but when i remove the line chart, the title populates fine. If i keep the title static it also populates fine. It just continues spinning if I have the title as some defined measure

if you have this figured out, please let me know it would be greatly appreciated!

thanks so much!

[PhilipTreacy]

Hi @dharsanj 

As your measure isn't doing anythign dynamic, why not just set the title directly in the Format area?

Regards

Phil