Support Power BI
Rechercher
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...
Lookup within a range of columns
Hello, I have the following problem: my table "Data" is Category 1 2 3 4 5 6 7&n...
Re: How do I share a report so non-PowerBI users can use it?
Thanks Dond, I don't have those options, so will get on to my IT dept. Here's what I can see in the 'Admin Portal'... Once I've 'published to web', will non-PowerBI users be abl...
Re: Gráfico de columnas apiladas: muestra solo valores filtrados como columna
Gracias por la respuesta. ¿Cambiaste alguna configuración?
Get latest date from one column based on a value from another column.
Hello, I need some help to get the latest date from one column based on a value from another column. let's say I have a table like this: ID_NAME NAME DATE_1 (day.month.year) ...
Días consecutivos desde que se perdió el objetivo
Hola a todos Como dice el título, ¿cómo cuento los días consecutivos desde que se superó por última vez un valor objetivo? Tengo un recuento de días por debajo del objetivo y días terminados,...
Extracción de pares clave/valor de json
Hola Comunidad, Estoy leyendo algunos datos de una tabla en Big Query y una de las columnas es una columna anidada que se extrae en PQ en formato JSON como este: {"v":[{"v":{"f":[{"v":"MA...
Re: Deneb - How to add measures on another dataset
Hey @AlexandreCoutoB. Look into performing a fold transform on your original dataset to get them into key-value pairs. This will be more aligned to the table format you're looking for. If th...
Re: Counting working days in DAX months
You can use the NETWORKDAYS function. https://dax.guide/networkdays/