Suporte do Power BI
Pesquisar
Re: bring currency value by using lookupvalue condition where period = M
Please tell me this thing.
Re: How to count cumulative on graph
Yes, it is possible to create a DAX formula to count cumulative totals in Power BI. You can use the following formula: Cumulative Total = CALCULATE(SUM(Table[Value]), FILTER(ALLSELECTED(Table), Tabl...
Date filter
I need to make a date filter and automatically filtered by last seven days without ignoring the rest of the dates in power bi? i tried to do using many ways but could not so i need any approved ideas
Suma columnas específicas de una matriz
Hola comunidad, Quiero crear una matriz que muestre cuántas personas estaban activas en una determinada dirección en un momento dado, sin embargo, SUMA ciertas direcciones como regiones específic...
Re: Unable to use parameter in query2 which uses query1 to get parameter values
@ShaliniUpputell he Formula.Firewall function in Power Query is used to control data privacy by preventing certain types of operations that can potentially expose sensitive data. It is...
Re: Sum Total issue
This issue could be caused by floating-point precision errors. When adding or subtracting numbers with many decimal places, the result may not be exactly what you expect due to the limited pr...
Problema con el filtro import y directQuery en la visualización
¡Hola! Estoy tratando de filtrar simplemente una visualización de tabla con otra visualización de dos tablas unidas por una conexión de modelo 1-1 Both. En este caso solo trato de probar entre ...
Re: Count most recent and consecutive streak of values IF values are <1
Hi FreemanZ, Unfortunately, the ones that have only blanks are the one with get a count of 52 (52weeks). It works great for the other ones though, as you can see from my screenshot below. ...
Error de autenticación de BigQuery en un paso "List.Transform" en Power Query
¡Hola a todos! Recibo un error de autenticación después de un paso en el que creo una lista con "List.Transform" que depende de otras columnas. La situación es extraña porque puedo trabajar...
How to show 'Vs Target %' for the month based on Today
Hi all, Currently I have a graph showing how the business is doing for the Month vs the Target for the month and the Year previous. Below this we have a Card showing the high level values. (...
How to make database/Power platform environment Read only
HI I have to make Power Platform environment's Database to Readonly when specific capacity is reached either using Power Apps, Power Automate, Powershell or from COE I have already checked ...
Re: Create a column based on criteria in other two columns in the data set
@key_to EarliestSalary = CALCULATE ( MIN ( 'Employee' [Salary]), FILTER ( ALL ( 'Employee' ), 'Employee' [EmployeeID] = EARLIER ( 'Employee' [EmployeeID]) &a...
Re: Color de fondo - ¿En qué campo deberíamos basar esto?
No es posible aplicar directamente formato condicional basado en una columna calculada en Power BI. Sin embargo, hay una solución que puede probar. Cree una medida que devuelva 1 si la columna MS10 ...
Evaluate values in column B, for each distinct value in column A and return result in column C
Hi, I am trying to make a new column for my dataset. Below is a basic representation of my data. In column C (ready to go home) I want to say that if all animals of the ...
Re: Embed Yammer - Viva comprometida con PBI Desktop
Hi Rico, Espero que estés bien. Muchas gracias por su respuesta. No quiero analizar los datos de Yammer. Quiero incluir la página web de yammer en mi informe. Por favor, vea a continuaci...
Re: How to create Power BI shared dataset from Web Application
Hi, I am looking the sample c# code - how to assign the dataset available in the c# application to the POWER BI workspace or Power BI shard dataset.
Re: Not specified users in Usage Metrics report
When users access Power BI reports through the pinned Power BI app button in Microsoft Teams, they may not be automatically tracked as viewers in the Usage Metrics report. This is because accessing t...
Re: How to build a data set from a valid PBI Service DSN (on-premise gateway) ?
Thanks for the reply. I don't get a machine datasource option. Is it the case that Power BI desktop needs to be running on the machine hosting the gateway ?
Rank in Card visual with filter
Hi, I have the below table Company Group Premium Company 1 4,102,813 Company 2 132,970,639 Company 3 46,137,791 ...
Re: Tema JSON - Error de gráfico de área + Eje secundario
Lo sentimos, el punto 2 está funcionando bien ahora. Debe ser un error temporal o algo así. ¿Puede ayudarme con el punto 1? Gracias.
Re: JSON Theme - Area Chart bug + Secondary Axis
Sorry, point 2 is working fine now. It must be a temporary bug or something. Can you please help me with point 1? Thanks.
Count IDs that existed last month but dont exist this month -> new customer
I have a sales table with a Customer ID column and a date collum. Each ID stands for a customer that generated Revenue in that month. I want to find out how many new customers I got and ho...
Re: COLLUM DONT DISPLAY LABEL
It work! I think that pbi will fit to show all time but not. If it's too large it just dont show. Thanks
Re: Measure includes all date
So, the only solution I found to fix it, is to create a new table containing all dates values. Then I use it in my chart. this solve the issue, but I am still persuaded it can be solved my reworking...
How to union two date columns into one
Hi, I have two columns that I would like to UNION into one column (like how you'd do in SQL) - is there any way to do this in Power BI. I dont want to merge them - I just need them combine...