Power BI-Support
Suche
Re: Pass Username/Password on iFrame Embed with Report Server
Little bit hint: Simple Add https://username:password@url
Re: % share of the total sales for each month
@newbie9292 , there is a small changes in the formula. Can you modify and try this formula now? Instead of ALL use ALLEXCEPT ( 'MyTable', MyTable[Year]) ) Sales % = VAR _sumOfSales ...
Re: Assigning Values based on conditions
hi @Ttaylor9870 what do you mean by No of rows opposed to Amount?
Re: Refreshing a dataset in Power Bi fails until another user makes themselves owner of it
Hello, I've stumbled upon a similar error. Don't know if it's relevant, but the table that is failing to refresh is from a Sharepoint file. In my case, the file is populated with new lines or chang...
meses en las columnas en lugar de en las filas
Buenos días Estoy tratando de crear una tabla similar a la imagen 1 en la que los meses están en las columnas. Sin embargo, en el nuevo modelo, tengo una tabla de hechos como calendario y los mes...
Apply filter for column PowerBI desktop
Hi guys, Hope you can help. See my table attached. In PBI I have added the SUM of revenue of all opportuniti...
months in the columns rather than in the rows
Good morning, I am trying to create a table similar to picture 1 in which the months are in the columns. However, in the new model, I have a fact table as a calendar and the months are...
Re: Store row value in a var.
hi @StuartSmith Var RequiredStaff = 'Master Data'[Required Staff] works only when you have a proper row contex. Otherwise, try like: Var RequiredStaff = MAX('Master D...
cómo usar los campos Registros sin expandirlo
necesito saber cómo usar los campos Registros sin expandirlo en una visualización ?
Re: Clickable Heatmap
Tooltips! thanks for the heads up will get googling these.
Re: Mapa de calor en el que se puede hacer clic
¡Información sobre herramientas! Gracias por los avisos conseguiré googleando estos.
Re: Error of gateway
Hi Microsoft Community Support Team, I tried what you asked for but again the error occurred. So, basically what I am trying to do is there are multiple data files from a single server and the da...
Re: DAX: What's wrong with my DAX measure?
@newbie9292 Well, there's a lot wrong like using auto-time intelligence, using VALUE, etc. But, as for the duplicate rows, perhaps you are missing a relationship? It's hard to say exactly.
Re: Nested IF Statement Query using PowerQuery not giving all the desired results
Thanks for the suggestion, however when I edit the lines to add the brackets: [[SIO Status] = "Active" or [SIO Status] = "End Dated" or [SIO Status] = "No SIO"] and Text.Start([Cost Centre I...
Cambiar el formato de fecha a MM-dd-aaaa desde tipos de datos mixtos en la columna Atributo
En la columna Atributo, tengo tipos de datos mixtos. Y quiero mantener todo en la columna Atributo para la matriz visual. Quiero cambiar la fecha (solamente) a Formato MM-dd-aaaa. ¿Cómo puedo ...
Re: Valores similares para igualar un valor común
Algo similar a esto debería funcionar. Busca NHP en la columna A, sin importar el caso, y devuelve NHP si se encuentra, de lo contrario, devuelve el valor original de ColA. CustomCol = IF(CONTAINS...
Count meetings per person if person is present in any of multiple columns
Hi, I can't seem to wrap my head around how to calculate this using DAX. I hope one of you clever people would be able to help me. I have a table of sales reps: SalesRepName | MeetingOwner...
Re: Trazar la ubicación de recogida y entrega en Power BI
@santhiya , ¿Está buscando un mapa de ruta? https://www.youtube.com/watch?v=ywYF7tYBsy0
Help with Add columns across two tables
Hello, I am having an issue with adding multiple columns across two table which are connected through "Date" field. First table hosts item sales data, while second table has "Dates" spanned ...
Y o Count DAX Measure no da el resultado correcto
Hi Expertos Estoy tratando de resolver lo siguiente basado en la tabla a continuación ... Si Worktype = RW y MEUCOMPLIANCEIMPACT = 1 y Status "CAN", entonces cuente o de lo contrari...
Combine parameter with a different column?
Hi, I'm trying to create a parameter which I want to use in a formula for a different table, but for some reason the column type doesn't recognize that it is a value? Do someone have a solut...
Re: Calculating Total Employees each Month
Please see attached full shot of the measure. I basically would like to get the figures below. So during December 2022 I had 179 Employees with a start date equal or less than 31/12/2022, and ...
Will PowerBi Desktop be removed?
Hello everyone, I wonder more and more about the future of Power Bi Desktop. Indeed, as updates are made, the various functionalities available on Power Bi Desktop are now achievable on Power Bi Ser...
Re: Informe - Tabla visual - permitir al usuario del informe ocultar columnas
Hola @asbpowerbi , Puede agrupar todas estas columnas en un parámetro de campo y agregar el valor del parámetro en la tabla, luego podrían cambiar el valor del campo dentro de una segmentación de...
Re: RANKX when “Product” appears on multiple rows?
Hello @tarmerj1 THANK YOU! Both of your options work, but option 1 is my desired result. I am going to use: $ RANK = RANKX(ALLSELECTED(ItemRANK), CALCULATE(SUM(ItemRANK[Dol$ Sales])), ,DESC)...