"Show as a Table" not working in Line and clustered column charts

[TradSag]

Hi,

Seems there is an issue with "Show as a table" function in both, destkop and service.

Error description:

When I try to see the data behind a chart using "Show as a table" function, the application provides me an error. This happening just in Line and clustered column charts, having a bar type measure and 2 lines type measures.  In other charts the functionality is working as expected. The error log is the following:

Error Message:
An error occurred while rendering the report.

Stack Trace:
TypeError: Cannot set property 'valueSourceIndex' of undefined
at ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:10935:60
at cloneTreeExecuteOnLeaf (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11200:36)
at Object.cloneTreeExecuteOnLeaf (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11196:44)
at projectIntersectionValues (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:10913:69)
at projectMeasures (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:10888:122)
at Object.apply (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:10869:68)
at applyProjectionOrder (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:12047:79)
at transformDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:12017:31)
at transformQueryToVisualDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11989:66)
at Object.apply (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:11964:447)

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__DisplayClass14_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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass2_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 set property 'valueSourceIndex' of undefined

Thanks and regards

[v-qiuyu-msft]

Hi @TradSag, 

I'm not able to reproduce the issue with the latest Power BI desktop version 2.79.5768.1082. You can test our sample report on your side, check if the issue is related to measures. 

Best Regards,
Qiuyun Yu

[TradSag]

Hi,

I have tried the sample report and yes, is working. Anyway, in my charts this is still not working, but is correctly visualising the data in the chart itself. 

Check the image below how the chart is correctly rendering the bar and the lines but is no able to "show as a table". Even more, if I convert the chart into a table visualization, the information appears correctly and I can use the functionality "show as a table" without any problem.

Can you please check?

Best regards

[v-qiuyu-msft]

Hi @TradSag, 

How did you create this problematic chart? Is it possible for you to recreate the issue with our sample report then share it with us? So we can try to analyze the issue on our side. 

Best Regards,
Qiuyun Yu

[Anonymous]

Hi,

We have been able to recreate the issue with the sample report.

Step1. Create the calculated column:

RegionTitle = "Measure by "& SELECTEDVALUE(DimSalesTerritory[SalesTerritoryGroup])

Step2. Filter a single Territory Group in the page

Step3. Compose a column/line chart like the following (using two measures as reference lines):

Step4. Use the calculated column RegionTitle as dynamic title

Step5. Click show as a table option and you will get the error

The same process for a common line chart using the dynamic title from the calculated column RegionTitle works ok as expected:

[v-qiuyu-msft]

Hi @Anonymous, 

Thank you for your detail information. I have reported this issue internally: CRI 188801857. Will update here once I get any information. 

Best Regards,

Qiuyun Yu

[v-xuding-msft]

Hi @TradSag , @Anonymous ,

The issue had been fixed. Please have a try. Hope it is working perfectly on your side.

[TradSag]

Hi,

This is good news! 😊

Should we assume that the fix is included in August 2020 release?

Many thanks!

Reegards