Line and Stacked Column Chart

[Anonymous]

Hi, I have a line and stacked column chart that used to work fine. Now I get the error message below.
The error seems to occur whenever I have both line data and column data, if I remove one, the error goes away. I don't know why this has suddenly happened.
I have cleared the cache and reinstalled PowerBI but nothing works.

If I can't fix it, I will need to rebuild the whole model from scratch and all the service reports, which is weeks of work.

Can you help with the error?

Thanks, James

Feedback Type:
Frown (Error)

Timestamp:
2021-03-09T17:08:20.5346655Z

Local Time:
2021-03-09T17:08:20.5346655+00:00

Session ID:
8e4e98a0-8e19-4432-81c8-572176727de7

Release:
February 2021

Product Version:
2.90.782.0 (21.02) (x64)

Stack Trace:
Microsoft.PowerBI.Client.Windows.JavaScriptException
TypeError: Cannot read property 'source' of undefined
at filterVariantMeasuresCategorical (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11441:90)
at filterVariantMeasures (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11381:49)
at Object.apply (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11373:17)
at transformDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:13768:48)
at transformQueryToVisualDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:13737:61)
at Object.apply (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:13711:447)
at VisualComponentCore.transformAndValidateDataViews (ms-pbi://pbi.microsoft.com/minerva/scripts/VisualHostUI.js:668:73)
at VisualComponentCore.<anonymous> (ms-pbi://pbi.microsoft.com/minerva/scripts/VisualHostUI.js:781:59)
at step (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:153:23)
at Object.next (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:105:20)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.90.782.0","ModuleName":"ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js","Component":"","Error":"TypeError","MethodDef":"filterVariantMeasuresCategorical","ErrorOffset":"11441:90"}

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
42.3 GB

Private Memory:
4.19 GB

Peak Working Set:
4.3 GB

IE Version:
11.1198.18362.0

User ID:
0a422eae-7caf-4029-b553-2877159992f0

Workbook Package Info:
1* - en-GB, Query Groups: 3, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_compositeModelsOverAS
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Recent Actions:
AddFieldInRole, RemoveProjection, AddFieldInRole

DPI Scale:
100%

Supported Services:
Power BI

[v-lili6-msft]

hi

I have tested on my side, it works well.

and please use latest version to have a try. Version: 2.90.1081.0 64-bit (February 2021)

https://www.microsoft.com/en-us/download/details.aspx?id=58494

if still have the problem, please share your sample pbix file for us have a test.

Regards,

Lin

[Anonymous]

Hi Lin,

Thank you for the link. I used it to instal Power BI desktop.

The issue with the line and stacked chart has now been resolved in the desktop version of Power BI.

However, when I look at the same report (and any report linked to that model) in the service, the graph is still blank. I have tried using different browsers (Edge, Chrome and Firefox) and also clearing the browser cache but this does not help. Do you know how it can be fixed in the desktop but not the service?

As I mentioned previously, when I remove the line value, the graph will reappear but when I add it back in it will go blank.

Any help would be much appreciated.

James

[v-lili6-msft]

hi

I tested it in power bi service, It works well too.

could you please share your sample pbix file for us have a test, that will be a great help.

Regards,

Lin

[Anonymous]

Hi Lin,
How do I share the PBIX file?

Thanks,

James

[v-lili6-msft]

You can upload it to OneDrive for business and post the link here. Do mask sensitive data before uploading.

Regards,

Lin

[Anonymous]

https://myoffice.accenture.com/:u:/g/personal/james_ford_accenture_com/Ec7233a5HMRFt_aRS01kj40BXLpaV... 

Hi Lin,

This is the link. 
Thanks again,

James

[v-lili6-msft]

hi

I couldn't get it.

Regards,

Lin

[Anonymous]

Hi Lin,

If you cannot access the PBIX file then how can we solve this?

What possible things would cause a line and stacked chart to work in the desktop version of Power Bi but not work in the service?

Thanks
James

[v-lili6-msft]

hi

It works well on my side, and here is my sample pbix file.

https://qiuyunus-my.sharepoint.com/:u:/g/personal/linli_qiuyunus_onmicrosoft_com/EZWDxiwB1jhEgo79KB5...

Regards,

Lin