Forum Discussion

PekkaKytosaho's avatar
PekkaKytosaho
Frequent Visitor
5 years ago

Error adding constant lines to scatter chart

Error with both X and Constant lines. Trend line works. Please help.

 

4 Replies

    • PekkaKytosaho's avatar
      PekkaKytosaho
      Frequent Visitor

      Thank you for your quick reply ðŸ˜€

      Version: 2.88.802.0 64-bit  December 2020

       

      Feedback Type:
      Frown (Error)

      Error Message:
      An error occurred while rendering the report.

      Stack Trace:
      (at TypeError: Cannot read property 'id' of undefined
      at AnalyticsCardControllerBase.addInstanceAction (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1435:45)
      at ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1426:30
      at UndoRedoStack.register (ms-pbi://pbi.microsoft.com/minerva/scripts/explore.js:15796:163)
      at UndoRedoService.register (ms-pbi://pbi.microsoft.com/minerva/scripts/explore.js:15756:52)
      at UndoRedoService.register (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:32272:39)
      at AnalyticsCardControllerBase.addInstance (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1425:36)
      at fn (eval at compile (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16508:15), <anonymous>:4:181)
      at AnalyticsInstanceSelectorController.destination.<computed> [as addInstance] (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:11497:22)
      at AnalyticsInstanceSelectorController.addInstanceAndSetFocus (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:3381:18)
      at fn (eval at compile (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16508:15), <anonymous>:4:192):line:null:)
      TypeError: Cannot read property 'id' of undefined
      at AnalyticsCardControllerBase.addInstanceAction (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1435:45)
      at ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1426:30
      at UndoRedoStack.register (ms-pbi://pbi.microsoft.com/minerva/scripts/explore.js:15796:163)
      at UndoRedoService.register (ms-pbi://pbi.microsoft.com/minerva/scripts/explore.js:15756:52)
      at UndoRedoService.register (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:32272:39)
      at AnalyticsCardControllerBase.addInstance (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:1425:36)
      at fn (eval at compile (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16508:15), <anonymous>:4:181)
      at AnalyticsInstanceSelectorController.destination.<computed> [as addInstance] (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:11497:22)
      at AnalyticsInstanceSelectorController.addInstanceAndSetFocus (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreUIShell.js:3381:18)
      at fn (eval at compile (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16508:15), <anonymous>:4:192)

      Stack Trace Message:
      An error occurred while rendering the report.

      Invocation Stack Trace:
      at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
      at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
      at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
      at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
      at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
      at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<SendAndMarshalExceptions>b__0(Object null)
      at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
      at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
      at System.Delegate.DynamicInvokeImpl(Object[] args)
      at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
      at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
      at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
      at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
      at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
      at System.Windows.Forms.Control.WndProc(Message& m)
      at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
      at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
      at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
      at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
      at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
      at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
      at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
      at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
      at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
      at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
      at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
      at Microsoft.PowerBI.Client.Program.Main(String[] args)


      JS Error Message:
      Cannot read property 'id' of undefined

      PowerBINonFatalError
      Snapshot Trace Logs:

      Model Default Mode:
      Import

      Model Version:
      PowerBI_V3

      Is Report V3 Models Enabled:
      True

      Performance Trace Logs:

      Enabled Preview Features:
      PBI_shapeMapVisualEnabled
      PBI_NewWebTableInference
      PBI_ExcelTableInference
      PBI_v3ModelsPreview
      PBI_azureMapVisual
      PBI_dataPointLassoSelect
      PBI_anomalyDetection
      PBI_newFieldList
      PBI_cartesianMultiplesAuthoring

      Disabled Preview Features:
      PBI_SpanishLinguisticsEnabled
      PBI_JsonTableInference
      PBI_ImportTextByExample
      PBI_qnaLiveConnect
      PBI_eimInformationProtectionForDesktop
      PBI_compositeModelsOverAS
      PBI_narrativeTextBox
      PBI_dynamicParameters

      Disabled DirectQuery Options:
      TreatHanaAsRelationalSource

      Cloud:
      GlobalCloud

      PowerBIUserFeedbackServices_IsReported:
      True

      Formulas:


      section Section1;

      in
      #"Filtered Rows";

      Active Section Contract:
      {"id":65040341,"name":"ReportSection","displayName":"STRIP AVG vs ST.D","filters":"[]","ordinal":0,"visualContainers":[{"id":970064071,"x":0,"y":0,"z":0,"width":736,"height":720,"config":{"name":"fb2631d4757ebde0711f","layouts":[{"id":0,"position":{"x":0,"y":0,"z":0,"width":736,"height":720}}],"singleVisual":{"visualType":"scatterChart","projections":{"Y":[{"queryRef":"summary1.Deviation"}],"X":[{"queryRef":"CountNonNull(summary1.Current average)","active":true}],"Series":[{"queryRef":"summary1.Motor"}],"Tooltips":[{"queryRef":"CountNonNull(summary1.Robot Number)"}]},"prototypeQuery":{"Version":2,"From":[{"Name":"s","Entity":"summary1","Type":0}],"Select":[{"Column":{"Expression":{"SourceRef":{"Source":"s"}},"Property":"StDev (mA)"},"Name":"summary1.Deviation"},{"Column":{"Expression":{"SourceRef":{"Source":"s"}},"Property":"Average (mA)"},"Name":"CountNonNull(summary1.Current average)"},{"Column":{"Expression":{"SourceRef":{"Source":"s"}},"Property":"Motor"},"Name":"summary1.Motor"},{"Aggregation":{"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"s"}},"Property":"Robot Number"}},"Function":3},"Name":"CountNonNull(summary1.Robot Number)"}]},"columnProperties":{"CountNonNull(summary1.Robot Number)":{"displayName":"Robot Number"}},"drillFilterOtherVisuals":true,"filterSortOrder":3,"objects":{"bubbles":[{"properties":{"bubbleSize":{"expr":{"Literal":{"Value":"-15L"}}},"markerShape":{"expr":{"Literal":{"Value":"'circle'"}}},"showSeries":{"expr":{"Literal":{"Value":"true"}}}}},{"properties":{"markerShape":{"expr":{"Literal":{"Value":"'triangle'"}}}},"selector":{"data":[{"scopeId":{"Comparison":{"ComparisonKind":0,"Left":{"Column":{"Expression":{"SourceRef":{"Entity":"summary1"}},"Property":"Motor"}},"Right":{"Literal":{"Value":"'Strip conveyor A (01)'"}}}}}]}}],"legend":[{"properties":{"position":{"expr":{"Literal":{"Value":"'BottomCenter'"}}},"fontSize":{"expr":{"Literal":{"Value":"14D"}}},"labelColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}}}}],"xAxisReferenceLine":[{"properties":{"transparency":{"expr":{"Literal":{"Value":"50D"}}}}}],"y1AxisReferenceLine":[{"properties":{"transparency":{"expr":{"Literal":{"Value":"50D"}}}}}],"categoryLabels":[{"properties":{"show":{"expr":{"Literal":{"Value":"false"}}}}}],"dataPoint":[{"properties":{"fill":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":9,"Percent":0}}}}}},"selector":{"data":[{"scopeId":{"Comparison":{"ComparisonKind":0,"Left":{"Column":{"Expression":{"SourceRef":{"Entity":"summary1"}},"Property":"Motor"}},"Right":{"Literal":{"Value":"'Strip conveyor A (01)'"}}}}}]}},{"properties":{"fill":{"solid":{"color":{"expr":{"Literal":{"Value":"'#118DFF'"}}}}}},"selector":{"data":[{"scopeId":{"Comparison":{"ComparisonKind":0,"Left":{"Column":{"Expression":{"SourceRef":{"Entity":"summary1"}},"Property":"Motor"}},"Right":{"Literal":{"Value":"'Strip conveyor B (02)'"}}}}}]}}],"categoryAxis":[{"properties":{"labelColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"fontSize":{"expr":{"Literal":{"Value":"10D"}}},"titleColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"titleFontSize":{"expr":{"Literal":{"Value":"16D"}}},"gridlineThickness":{"expr":{"Literal":{"Value":"3D"}}}}}],"valueAxis":[{"properties":{"labelColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"fontSize":{"expr":{"Literal":{"Value":"11D"}}},"titleFontSize":{"expr":{"Literal":{"Value":"16D"}}},"gridlineThickness":{"expr":{"Literal":{"Value":"3D"}}}}}],"fillPoint":[{"properties":{"show":{"expr":{"Literal":{"Value":"true"}}}}}]},"vcObjects":{"title":[{"properties":{"text":{"expr":{"Literal":{"Value":"'STRIP CONVEYORS'"}}}}}],"visualTooltip":[{"properties":{"section":{"expr":{"Literal":{"Value":"'ReportSectione52dcc6b47cfbc784195'"}}}}}]}}},"filters":"[{\"name\":\"Filtere0fbfcfcdc1f3a520576\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Motor\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"summary1\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Motor\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Strip conveyor A (01)'\"}}],[{\"Literal\":{\"Value\":\"'Strip conveyor B (02)'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"objects\":{},\"isHiddenInViewMode\":true,\"ordinal\":0},{\"name\":\"Filter6ead4ef35f8b824a75ec\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Average (mA)\"}},\"type\":\"Advanced\",\"howCreated\":0,\"isHiddenInViewMode\":true,\"ordinal\":1},{\"name\":\"Filter970390b556566611d3e7\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"StDev (mA)\"}},\"type\":\"Advanced\",\"howCreated\":0,\"isHiddenInViewMode\":true,\"ordinal\":2},{\"name\":\"Filter64aa54f0d6fa37a76107\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Robot Number\"}},\"type\":\"Advanced\",\"howCreated\":1,\"isHiddenInViewMode\":true,\"ordinal\":3},{\"name\":\"Filterb766969926c973c17599\",\"expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Robot Number\"}},\"Function\":3}},\"type\":\"Advanced\",\"howCreated\":0,\"isHiddenInViewMode\":true},{\"name\":\"Filter7fa5226eee3b96fdfd10\",\"expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Robot Number\"}},\"Function\":4}},\"type\":\"Advanced\",\"howCreated\":1,\"isHiddenInViewMode\":true},{\"name\":\"Filtera24840ff0c87b8f6c4a1\",\"expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"summary1\"}},\"Property\":\"Robot Number\"}},\"Function\":5}},\"type\":\"Advanced\",\"howCreated\":1,\"isHiddenInViewMode\":true}]"}],"objectId":"fb36d835-5eb7-41d5-b678-e0ce53dbaaa5","config":{"type":0},"displayOption":1,"width":1280,"height":720}

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support

      Hi PekkaKytosaho ,

       

      I did not reproduce your problem, My Desktop version is 2.88.1144.0 64-bit (December 2020).

      Please update to the latest version.

      If the problem is still not resolved, please share a sample .pbix file.

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.