Power BI-support
Sök
Secuencia aritmética con cortadora
Hola grupo! Pocos días estoy tratando de resolver un problema de cómo crear una "columna calculada" y hacer un promedio de ella, pero aún no tengo éxito. MIndex es la columna lo que necesito...
PBI - API delete (some) rows
Hello hello community, given a push dataset in PBI, it is possible to delete all the rows via delete request to the REST API: Push Datasets - Datasets DeleteRows - REST API (Power BI Power BI R...
Can I create template for my powerbi?
Dear Community, Can you please help me with my first steps in powerbi. So i have finished my powerbi file creation - all visuals are created, Transform data is done. Now I want to ...
Re: Ordenar la leyenda del gráfico de barras por el valor Y de cada barra
Por lo tanto, sugiere crear una columna calculada con el índice de clasificación para el campo Empresas. A continuación, ordene el campo Empresas por esa columna en la vista de datos. Lo intentaré...
Re: Count the number of students if their admission or leaving date is in the same year-month
Hi @v-shex-msft, Thanks for following up with this and pointing me to the relevant resources. There were countless attempts with those DAX (some provided by ChatGPT) with various error messages...
Re: Create a scrolled column down
Hello @Syndicate_Admin , check if this solution works https://community.powerbi.com/t5/Desktop/New-column-to-populate-previous-value/m-p/223379 If I answered your que...
Re: Sorting a Parent - Child Hierarchy
Hi @CVance Try to create two seperete sort columns for Year and Weekend date and Sort Year to Year sort column and Weekend Date to Weekend Date Sort column. This should work and we can ...
Re: Accessing Dataset in Excel
Bump, I'm having the *exact* same issue...I'm running the latest Excel and the latest PowerBI Desktop app from the MSFT store so not sure what's triggering this
Re: Pro rata based on duration according to month
Hello @lbendlin, Here is a sample of my dataset. YEAR START DATE END DATE DURATION FIRST TYPE SECOND TYPE 2022 01/01/2022 15/02/2022 45 A / 2023 15/03/2023 18/05/2023 64 ...
Re: DatamartVersionMismatch is causing much pain
Also - this is unrelated, sorry - but I'm new to Power BI and started my learning journey with datamarts. Due to few issues like this one cropping up, I thought I'd look into using PowerB...
Re: Unable to refresh dynamic source (REST API) in powerBI service
Hello Alisa, When I hit the refresh button from PowerBI Desktop, it refreshes my data and I see updated numbers in the visuals. If not supported then, the refresh will not work at my deskto...
Power BI Alerts option is not visible
Hello everyone, I would like to set alerts for my figures in the Power BI report, but when I follow the steps to do so, the "manage alerts" option is not visible to me. I have read that it c...
Cumulative % in loan schedule
Hi, in my loan schedule I have calculated Interest payment with such function: Interest_Monthly = VAR _PV = [PV] var _Rate = MAX('Lig'[Rate in period]) var _Period = MAX('Lig_Project'[Seq]) va...
Actualización de abril de 2023: error de mashup / error de formato de datos
Hola a todos Tengo varios usuarios que se "quejan" de que algunos de sus informes no funcionan correctamente después de la actualización de abril de 2023. Están importando datos a través de J...
Re: Pro rata based on duration according to month
Hello @Ashish_Mathur, The colours are the type of my value, let me show you a sample of my dataset. YEAR START DATE END DATE DURATION FIRST TYPE SECOND TYPE 2022 01/01/2022 15/02/...
last known value
Hello , I have columns in my table : Date, Values Every date has some values corresponding to it and some dates have no values. I would like to add additional column of values which shows va...
Re: Quarter Value based on Date Range Filter
sorry, it turns out my data is wrong so that it affects when using the date slicer "both solutions can be used" thanks @v-rongtiep-msft and @amitchandak
Opening balance in amortization schedule
Hi, please help me to find correct way to calculate correct Opening balance = Previous period Closing balance. There is my expectation: There is my formula to calculate O...
Mostrar valor de la semana anterior
Hola chicos He creado 2 medidas de valor de apertura y valor de cierre semana sabio quiero ralentizar el valor de apertura de la nueva semana debería ser el valor de cierre de la semana anterior usa...
Último valor conocido
Hola Tengo columnas en mi tabla: Fecha, valores Cada fecha tiene algunos valores correspondientes y algunas fechas no tienen valores. Me gustaría agregar una columna adicional de valores que mues...
Re: Different result of measure and calculated column
Hi! Instead of var current_Opp_No = SELECTEDVALUE('PM Hours distribution'[Opportunity_Number]) var current_Project_Month_no = SELECTEDVALUE('PM Hours distribution'[Project Month]) &n...
Re: MySQL Connection Error
Hi @Neha_PowerBI, What version of power bi desktop client are you worked? Have you tried to test current connection on the last version power bi desktop? Regards, Xiaoxin Sheng
Re: Running total with incorrect subtotal column in a matrix table
@Greg_Deckler thanks for spending time on my case. No, the issue is not that one. Let me clarify with the picture of my matrix: If you look at Feb'23 column, total of the column show 6.28 wh...
Re: Calendario y actualización - No se puede encontrar la fuente del error
Gracias, pero he encontrado la solución mientras tanto. aunque no tiene mucho sentido. Acabo de cambiar la configuración regional a inglés desde los Estados Unidos. (Tenía como portugués (Portugal)) ...
Re: Power BI Dashboard does not refresh in Power BI Service
Hi @Silv , if you have the pro version then you have to set refresh in dashboard level refresh in power bi desktop. you can also set scheduled refresh in power bi service in the dataset o...