Visuals Break with "Error Fetching Data" When Filtering by Date (Import Mode Model)
Hi everyone, I’m facing an issue in Power BI where visuals break and display an “Error fetching data for this visual – An unexpected error occurred” message whenever I try to apply a date filter (as shown in the attached screenshot). Here are the key details: The data model is in Import mode. The error appears specifically when filtering data on TransactionDate (or any date column). The visuals work fine before applying the date filter. I’ve already tried refreshing the dataset and rebuilding the visual, but the issue persists. Has anyone else experienced this issue or found a solution/workaround for it? Any guidance would be appreciated. Thank you!
Problema con función SWITCH en campo calculado
Solicito su ayuda para resolver el siguiente escenario que estoy enfrentando: Estoy trabajando con una tabla de hechos que contiene los siguientes campos: Id_Transaccion Id_MedioPago MedioPago_Ezypass A continuación, presento un ejemplo de los registros involucrados: Id_MedioPago MedioPago_Ezypass 24 1 25 1 Mi intención es generar dos nuevos campos calculados llamados: FormaPago MedioPago En estos campos, quiero aplicar una lógica que: 1. Muestre los medios 24 y 25 de forma individual, es decir: 24 como "WOMPI NEQUI RECURRENTE" 25 como "WOMPI TC RECURRENTE" 2. Agregue un nuevo medio adicional llamado "EZYPASS", que represente la combinación de los medios 24 y 25, únicamente cuando el campo MedioPago_Ezypass = 1 El inconveniente es que, al implementar esta lógica con la función SWITCH en un campo calculado, solo se muestra una de las condiciones. Por ejemplo: Si se evalúa primero la lógica de "EZYPASS", solo se muestra "EZYPASS" y no los medios 24 y 25 individualmente. Y si se prioriza mostrar los medios individuales, entonces no se muestra "EZYPASS". Es decir, no se pueden visualizar los tres valores simultáneamente en un gráfico o tabla dinámica de Power BI. Adjunto la tabla puente que contiene la lógica de agrupación deseada para que tengan el contexto completo de cómo deben visualizarse los datos. Campo calculado MedioPagoAgrupado = VAR _IdMedioPago = FACT_Pagos[FACT Pagos.Id Medio Pago 1] VAR _FormaPago = SWITCH( TRUE(), _IdMedioPago IN {24, 25, 18}, "EZYPAY", _IdMedioPago IN {26, 21, 16, 7}, "FLUJO AUTOMÁTICO", _IdMedioPago IN {14, 19}, "PAGO DIRECTO", _IdMedioPago = 20, "SMARTPAY", _IdMedioPago IN {2, 3, 4, 6}, "POS", BLANK() ) -- GOPASS se trata diferente VAR _TipoGopass = IF( _IdMedioPago = 26, IF(FACT_Pagos[FACT Pagos.Antena] = "TRUE", "GOPASS TAGS", "GOPASS PLACAS"), BLANK() ) -- Obtener nombre real (puede ser Wompi, Ezypass, etc.) VAR _NombreMedio = LOOKUPVALUE( Tabla_Puente_Medios_Formas[MedioPagoAgrupado], Tabla_Puente_Medios_Formas[Id_MedioPago], _IdMedioPago, Tabla_Puente_Medios_Formas[FormaPago], _FormaPago ) -- Formar clave compuesta VAR _Clave = _NombreMedio & "|" & _FormaPago & "|" & FORMAT(_IdMedioPago, "000") RETURN IF( NOT ISBLANK(_TipoGopass), _TipoGopass, LOOKUPVALUE( Tabla_Puente_Medios_Formas[MedioPagoAgrupado], Tabla_Puente_Medios_Formas[ClaveCompuesta], _Clave ) ) Tabla puente Tabla_Puente_Medios_Formas = DATATABLE( "MedioPagoAgrupado", STRING, "FormaPago", STRING, "Id_MedioPago", INTEGER, "ClaveCompuesta", STRING, { -- EZYPAY {"WOMPI NEQUI RECURRENTE", "EZYPAY", 24, "WOMPI NEQUI RECURRENTE|EZYPAY|024"}, {"WOMPI TC RECURRENTE", "EZYPAY", 25, "WOMPI TC RECURRENTE|EZYPAY|025"}, {"DAVIPLATA", "EZYPAY", 18, "DAVIPLATA|EZYPAY|018"}, -- FLUJO AUTOMÁTICO {"EZYPASS", "FLUJO AUTOMÁTICO", 24, "EZYPASS|FLUJO AUTOMÁTICO|024"}, {"EZYPASS", "FLUJO AUTOMÁTICO", 25, "EZYPASS|FLUJO AUTOMÁTICO|025"}, {"CARROYA", "FLUJO AUTOMÁTICO", 21, "CARROYA|FLUJO AUTOMÁTICO|021"}, {"COPILOTO", "FLUJO AUTOMÁTICO", 16, "COPILOTO|FLUJO AUTOMÁTICO|016"}, {"FLYPASS", "FLUJO AUTOMÁTICO", 7, "FLYPASS|FLUJO AUTOMÁTICO|007"}, -- GOPASS {"GOPASS TAGS", "FLUJO AUTOMÁTICO", 26, "GOPASS TAGS|FLUJO AUTOMÁTICO|026"}, {"GOPASS PLACAS", "FLUJO AUTOMÁTICO", 26, "GOPASS PLACAS|FLUJO AUTOMÁTICO|026"}, -- PAGO DIRECTO {"QR BANCOLOMBIA", "PAGO DIRECTO", 14, "QR BANCOLOMBIA|PAGO DIRECTO|014"}, {"QR ESTATICO BANCOLOMBIA", "PAGO DIRECTO", 19, "QR ESTATICO BANCOLOMBIA|PAGO DIRECTO|019"}, -- SMARTPAY {"EFECTIVO", "SMARTPAY", 20, "EFECTIVO|SMARTPAY|020"}, -- POS (Pagos Payment) {"EFECTIVO", "POS", 2, "EFECTIVO|POS|002"}, {"TARJETA DEBITO", "POS", 3, "TARJETA DEBITO|POS|003"}, {"TARJETA CREDITO", "POS", 4, "TARJETA CREDITO|POS|004"}, {"ELECTRONICO", "POS", 6, "ELECTRONICO|POS|006"} } )
PowerBI RB, Data not outputting when Running
Good Morning all! I am creating an order acknowledgement for a company and have experienced an issue. I have created a table (the ones with a black box around them) successfully conecting to my datasource, pulling values named Ship2_address1, Ship2_address2, Ship2_name, Ship2_postcode and Ship2_city, as well as Bill2 for the same fields. I have also created a parameter to only output data relative to another field i've referrenced in another table (the one at the bottom of the page). However, when I try to run this document I do not get any data loading for my top two tables, but I do for my bottom one. To my knowledge I have configured them the same way I have as the bottom one. So far, I have tried reconnecting and testing my data source to ensure its correct (which it is), I have remade the table to ensure that the data fields are correct (the fields are correct) and I have removed and re-added the parameter to see if data can be brought out... I also do not have much experience with PowerBI as a whole so I may have just made a small minor mistake on this. If any clarification is needed on this matter please let me know Kind regards and looking forward to any replies, Avery
Rolling sum of tickets in status with start and end date
Hello, I'm trying to create a rolling sum mesure that counts the aggregated number of issues that are in "Analysis" status on a monthly basis. I need to base this rolling sum on the status start date and end date. The end goal is to have a visual that looks similar to this one : At the beginning a big number of issues are in the analysis status (it is one of the first status in our workflow) and it decreases over time and inversely, the number of validated issues is low and increases over time. Here's the sample data (I'm only interested in Analysis (En Analyse) and Validated (Validée) statuses : https://we.tl/t-IXS2ysHXoM Thanks in advance for any suggestions. Regards, IanaToolTip Advance - Filter Help
Hi all, I'm working on a Power BI report where I show monthly Gross Sales in a table and would like to display a tooltip chart when hovering over the table rows. The goal of this tooltip is to show the entire year's trend line for Gross Sales, not just the single month that was hovered. What I want: When hovering over a row (e.g., Brand 3), I want the tooltip to show a Bar chart for the full year (e.g., Jan–Dec ). The tooltip should still respect other slicers from the main page: e.g., State but ignore Month Slicer What I’ve Tried: Created a Tooltip Page. Enabled the page as a tooltip and linked it to the table. It works — but only shows a single month (the row context from the table). However, the date context from the hovered row still dominates the chart axis — only one Bar appears instead of the full year. What I Need Help With: How can I structure my tooltip chart (and DAX) to: Ignore just the row-level month/date from the hovered row Still respect the full context of slicers (State etc.) Always show the full year trend on the tooltip chart? File working
