Problema de filtrado cruzado

Syndicate_Admin · ‎06-05-2023

Hola

Tengo algunos problemas con la función de filtrado cruzado en mis informes.

Tengo una pequeña mesa:

Fecha	evento	usuario
06/06/2023	escanear	Temp1
06/06/2023	Impresión	Temp2
07/06/2023	escanear	Temp2

Y una tabla de fechas, generada con la función CALENDARAUTO(). También he añadido dos columnas a esta tabla:

Day of Week = SWITCH(WEEKDAY('Calendar'[Date]),
    1, "Sunday",
    2, "Monday",
    3, "Tuesday",
    4, "Wednesday",
    5, "Thursday",
    6, "Friday",
    7, "Sunday"
)

Date Formatted = LEFT('Calendar'[Day of Week], 3) & UNICHAR(10) & FORMAT('Calendar'[Date], "DD/MM/YY")

Así que la tabla de fechas es algo así como:

Fecha	Día de la semana	Fecha con formato
6/06/2023	Martes	Mar 06/06/23
7/06/2023	Miércoles	Mié 07/06/2023
... etc.

El informe funciona bien si utilizo la columna de fecha generada por la función CALENDARAUTO(). Pero si intento usar Date Formatted en una matriz, recibo el siguiente mensaje de error:

El siguiente es el mensaje de error:

Feedback Type:
Frown (Error)

Error Message:
An error occurred while rendering the report.

Stack Trace:
Javascript: TypeError
at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2760:62)
    at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2761:134)
    at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2761:134)
    at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2761:134)
    at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2761:134)
    at ElementBuilder.attachEventHandlers (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2761:134)
    at https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2766:44
    at Array.forEach ()
    at ElementBuilder.attachEventHandlersMultiple (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:2765:34)
    at TablixRendererFS.insertRowGroup (https://ms-pbi.pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:3611:51)

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.b__0()
   at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
   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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   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__DisplayClass6_0.b__0()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


JS Error Message:
Cannot read properties of undefined (reading 'childNodes')

¿Alguien tiene alguna idea de lo que puedo hacer aquí?