Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Syndicate_Admin
Administrator
Administrator

Problema de filtrado cruzado

Hola

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

Tengo una pequeña mesa:

Fechaeventousuario
06/06/2023escanearTemp1
06/06/2023ImpresiónTemp2
07/06/2023escanearTemp2

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:

FechaDía de la semanaFecha con formato
6/06/2023MartesMar 06/06/23
7/06/2023MiércolesMié 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:

vicky__0-1686024641714.png

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í?

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

@vicky_ ,

¿Qué versión de Power BI está usando?

Intente actualizar Power BI Desktop a la versión más reciente o revertir Desktop a la versión histórica y vea si el problema persiste.

Puede encontrar las versiones históricas de Power BI Desktop aquí:

Actualizaciones mensuales anteriores de Power BI Desktop y el servicio Power BI - Power BI | Microso...

Saludos

Jianbo Li

Si esta publicación ayuda, considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Top Solution Authors