Power BI-support
Sök
Escenario de filtrado de medidas
Necesito ayuda para solucionar un problema que tengo con una medida que se filtra incorrectamente para mis propósitos. Vea el escenario a continuación. TABLE_A Incluye columnas: [ Dirección de c...
Microsoft Fabric for Power BI Users
Join Mohini Verma and Raja Manzoor for an overview of exciting new capabilities in Microsoft Fabric, specifically for today's users of Power BI!
Re: Necesita ayuda con el gráfico Guage
Hola Gracias por los aportes. Pero, ¿cómo lograste mantener un color diferente después de la línea de destino? Este es uno de mis requisitos. Tengo otro requisito que es el siguiente. Necesito te...
Re: Text value alphabetically between two other values, resolved as TRUE/FALSE
@kpost as you said text will not work in the above case but what is the logic for grouping, maybe that can help to derive the solution.
Re: Conditional Formatting of Multiple Text Fields
Hi @ayeoh If I understand you correctly, then yes you can create 1 measure using OR on your condition: 7 columns test = IF(SELECTEDVALUE('Table'[column1])=TRUE() || SELECTEDVALUE('Table'...
¡Cómo usar múltiples filtros Top N!
Hola a todos! Soy nuevo en Power BI y estoy intentando crear un panel para mostrar los datos de ventas de 2022 y 2023 de cada empresa, pero el socio comercial quiere que filtre solo las 10 princi...
Data Source Credentials Invalid - From STAGING to LAKEHOUSE, Not touching Gateway
We are trying a new pattern to load data to get around the issue of long running queries not letting us load data into Fabric. The patter is loading smaller sets of data into staging as its own data...
Crear una medida que ignore el filtro específico que no funciona: Uso de ALL()
Hola Estoy tratando de calcular el recuento de días que un usuario trabajó mientras ignora un filtro específico. Cada día solo debe contarse una vez. Otros filtros deberían seguir funcionando. ...
Re: DAX formula working - not when filtered
Ignore me. I've had to change my filter to the 'Company' list from my new 'Companies' table, rather than having my field as' 'Company' from my 'Sick Leave' table. All good 🙂 Grateful for your help!
Re: Filters on display elements
Hi @Syndicate_Admin If you using a filter pane you just put your filter on the visualization level: If the issue is with the slicer you need to edit interactions with all visuals tha...
Re: Text value alphabetically between two other values, resolved as TRUE/FALSE
I absolutely can do it in SQL, as SQL allows comparing text using logical operators like <= etc. Maybe this is the best solution after all. Thanks.
Re: Cambiar el formato de número globalmente en todos los informes para usar M para miles y MM para millones
Muchas gracias por esto. Revisaré esos recursos
Re: Getting Current Month Dates in DatesMTD
Hi Ahmed, Thanks for the answer. This script did work but giving circular dependency error when connecting this table to existing data model
Re: Formato condicional de varios campos de texto
Ah, y pensé que querías marcar con verde todas las celdas si incluso una de las columnas de la fila es verde. Puedes ignorar mi última sugerencia con una bandera combinada. Tenga en cuenta que adju...
Re: Changing number format globally on all reports to use M for thousands and MM for millions
Here is an update on my issue. It is not a solution as it will only work for one measure at a time, but if you are trying to format a measure using the M or MM notation then you can use DYNAMIC forma...
Re: Show custom Date range based on the value selected in another column
@PRamashe how table A and B are related?
Re: Extract days from event, then count weekdays only - can do in DAX but can't get working in PQ/M
Pro rata divides total duration of leave by the number of weekdays - in this case they are all 1 but this is not always the case.
Re: Create a Measure which ignores specific Filter not working: Using ALL()
@adoster it will easier if you can share sample pbix using one drive/google drive and the expected output. Without knowing your data model and required output, it is very hard to decode the DAX ...
How to Slice Data from Two Objects in the Data Model?
My data model contains 2 objects that contain similar but different information. I've configured slicers to filter data from the Claims object. However, I need to also ensure that the PQI...
¿Cómo dividir datos de dos objetos en el modelo de datos?
Mi modelo de datos contiene 2 objetos que contienen información similar pero diferente. He configurado segmentaciones de datos para filtrar datos del objeto Claims. Sin embargo, también debo asegur...
Re: Need to show the negative duration
Thank you for your response!! Looks like I am getting close, what can I do return this just in mins? I tried this but doesn't look like its working. May be the format needs to be updated 00:00:...
Re: Necesidad de mostrar la duración negativa
Gracias por su respuesta!! Parece que me estoy acercando, ¿qué puedo hacer para devolver esto en minutos? Probé esto pero no parece que funcione. Puede ser que el formato deba actualizarse 00:00:00,...
Re: Power BI en línea a Power BI en línea a diferentes migraciones de dominios
@Shreesefwere Eche un vistazo a este artículo que cubre el tema de la migración de inquilinos. https://practical365.com/tenant-to-tenant-power-bi-migration/
Calculating median for a subset of data
Hello, I am having trouble with using multiple tables to summarize some historical data (I need the median and percentiles of counts each hour). The main fact table holds actions and action dates alo...
Re: Restrict who can create subscription
Creating WS should only be allowed for content creators (BI developers). if everyone can create a workspace you will be very unhappy after short time. It will go messy and you maybe you have an iss...