Power BI Support
Search
Re: Lastnonblankvalue problema de cálculo
Hola @Newuser13 Cree una tabla de calendario con una relación de uno a muchos con su tabla de hechos. Luego use el siguiente dax. Precio Nuevo = DÓNDE vLastDate = si(..max('Precio en bl...
Re: Límite de tamaño de datos del modo de importación de escritorio de Microsoft Power BI
gracias por esa respuesta, tengo otra pregunta para usted, si hospedo mi propio servidor de informes de power bi, ¿los espectadores de contenido necesitan sus propias licencias o la licencia gratuita...
Re: Expand a table of persons field from SharePoint for Power BI
I have the same issue and in the solution section there is no real solution for this problem (only additional links where no solution for this certain issue is found). A normal multiselection can be...
Re: Microsoft Power BI Desktop Import Mode Data Size Limit
Hello @BullGangGeneral , Premium Per User (PPU) tenants have a 100-TB storage limit. When you're using a Pro license, the total usage can’t exceed the tenant storage limit of 10 ...
Re: Count agregate
May I know, which visual you are using to display it.. Count will automatically consider the incomnig filter context and calculate it accordingly
Multiply by -1 the values of only one item in a table
Hello I need to reflect the values of the Other Income row of a table in negative, so that when grouping Other Expense and Other income these reflect the correct value, for this as I can multiply b...
Re: Can't switch storage mode to import
I'm pretty sure it is supported to switch individual tables to import mode, or at least it has worked for other DirectQuery databases I've used.
Re: Mismatch in status count
@QwertyMartijn Just use as below instead of using || symbol. Complaint[Status]"Completed",Complaint[Status]"Completed Subcontractor",Complaint[Status]...
Re: Remaining Balance per year with dynamic age grouping
Hi I don't have link for the PBIX File but above is the sample data. Thanks.
Re: Tip: Perspectives on a big Power BI dataset vs old multidimensional cubes (XMLA enabled only)
@Amit well I might have posted this in the wrong location, but it's not a question rather it's a tip. The situation above handles the situation when you already added perspectives with Tabular ...
Re: Power BI Embedded export data
Hi @tiaandp You can refer this link
Re: change formating based on account name
@akerrout , I think new dynamic format string can help https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/
¿Puedo también profundizar de un informe a otro en el escritorio?
Hola, en mi curso vi cómo se puede configurar el taladro a través de OTRO informe en el servicio. ¿Puedo entrenar a PBI antes en el escritorio para que haga lo mismo, es decir, no espere a la public...
Re: Crear una tabla donde cada fila tenga una fórmula específica
Terminé creando columnas para cada cheque y luego más columnas para cada resumen y resumiéndolas de todas las entradas.
Create a new conditional column with difference of dates
Hello everyone, I want to create a new conditional date : i have a column XXX with date (with some empty fields) and i want to create a new column with conditions : ...
Stacked Bar Chart Question
Hi Everyone! Is it possible to display 3 values together in a stacked bar chart somehow? I have 4 different account numbers and for each account I have the starting balance, total planned, and...
Re: icon color and broken image in search
Solved for me through support ticket. Seems to have been tenant specific... Sent: Thursday, May 25, 2023 8:57 PM Summary : ======== After receiving the case we have analyzed that yo...
Re: Custom Date Sort
@Xiaoxin Sheng Thank you , It worked. RM
Re: Returning Column Name of first non- Null value
Hi Add a new column List.Skip(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}), each _{0}=null){0}{1} Stéphane
Re: Cambiar el idioma de la aplicación
Gracias por compartir su preocupación por cambiar el idioma de la aplicación. Puede ser difícil navegar por tales aspectos técnicos, especialmente cuando se trata de configuraciones de idioma. Si est...
Add a Budget line to a line chart that changes with slicer options
I have a spreadsheet that contains budget info depending on Employee Name, Date, and Cost Centers. I am trying to add a budget line that will change depending on the option the end user selects. Ie...
Re: Valor del archivador de tabla sin ralizar en la segunda tabla.
Puede agregar una columna calculada a su tabla de ventas día a día, como SlicerCol = IF( Sales[Data Date:] = MIN( SingleDate[DataDate] ), "The Date", "Not The Date" ) O puede agrega...
Re: Reports loading screen
Hello - we have a report in our organisation where this is increasingly happening as well. It is only an issue in our most used report, others are fine. We are using a live connection ...
Re: Dynamic columns with filter
@Syndicate_Admin Please Refer Below Link https://youtu.be/nWgPynP9XDM @Syndicate_Admin I hope this helps you!!THANK YOU!!
Re: Subscriptions to Paginated Reports are losing Parameters and returning to defaults.
Same issue, I'm Power BI Admin, and I have 1 report with 1 parameter that contains 24 regions, I programmed 24 subscriptions to deliver that report to 24 regions (different emails) and it used to ...