Power BI Support
Search
Re: Calcular el pronóstico de ingresos en el año calendario actual
De nada. Alguien más te ayudará con esto.
Re: ISSUE: data refresh linked Excel-files on Sharepoint-site is flawed
Hi @hulsbergenw Your data is stored in SharePoint, so it will excute OneDrive refresh, If you edit the .csv file in OneDrive, or SharePoint, after you save, those changes ...
Re: Display last month in MMM-YY format
Hi, Thanks for the answer given but unfortunately it doesn't work. When I select all months it doesn't seem to be displaying the correct month, and when i select one month it just disp...
Re: DAX CODE BRINGING COLUMNS FROM TWO DIFFERENT TABLES
Hi @Aydeedglz , Please try: EVALUATE ADDCOLUMNS( FILTER( TABLE1, TABLE1[COLUMNFILTER1] = "Open" && TABLE1[COLUMNFILTER2] = "Yes" && ...
Re: how to create range with data
Hi @esam You can refer to the following example 1.Create the calculated table Table = var a=GENERATESERIES(1,100/5,1) return ADDCOLUMNS(a,"Range",[Value]*5-5&"-"&[Value]*5) ...
Re: Can not find "align zero" in Line Chart settings
Thank you @v-yueyunzh-msft I suggest an Power BI Idea here.
Re: What happens after the trail period of Microsoft Fabric
Hi @Hennie1234 Thanks for posting your question in Microsoft Fabric Community After the trial period of Microsoft Fabric expires, you will need to purchase a license to continue using the...
Re: Dynamic To date measures
@DataFab2023 , if you just want to show data, not trend New measure = var _max = maxx(allselected(Date),Date[Date]) var _min = minx(all(Date), Date[Date]) return calculate( sum(Table...
Re: Cumulative difference in power bi
Hi, I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below. Please check the below picture and the attached pbix file. ...
Re: Custom filled map - how to colour a custom area map based on a date slicer
@Sambath , refer, if this approch can help Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
Re: Single sign on error in a report which the same visualizations in it's dataset works fine
Hi @sarkani , According to your error message.You have used Direct Query connection mode in Power BI to connect to a datasource with a calculated column or a calculated table, which is c...
power bi rest api - execute query against dataset
Hi, I have a scenario where user enquires about using the Power BI REST API to query dataset data (via Power Automate). The dataset in question is deployed via an app with build permissions ...
Re: SUMX with visual filters
Hi @Syndicate_Admin , According to your description, here are my steps you can follow as a solution. (1) My test data is the same as yours. (2) We can create a measure. ...
Re: Share Report in Mobile App with External Users
Personal accounts are not supported, only institutional or educational ones. Outside of the organization, you can share and read reports, but only if the user you're sharing with is also part of your...
Re: 3 diff Percentage --> 2 Percentage
The accompanying PBIX file passed my inspection. wordle unlimited
Re: MedianX Function
Hello, The Customer Achi% in my question is output of measure, hence i am not able to apply the above solution. Please advice Regards Prashanth
Re: Fórmula
Hola @Augustas-ase , esto es lo que puedes hacer lo siento, % de ventas = var _sumOfSales = [Ventas 2022] <- su medida aquí. var _percent = Calcular(_sumOfSales,ALL(Table'Categor...
Conexión de API en powerBI
Hola a todos Tengo una API con SCROLLID. cuando la API se ejecuta por primera vez, no hay ningún ScrollID. La primera llamada devuelve un ScrollID para 2ª, 2ª llamada devolverá ScrollID para 3ª y...
Re: Función MedianX
Hola Sus resultados 😞 en blanco devuelven Saludos Prashanth
Re: Dynamic Axis - January 2021 Version
@ajimenez05 , If you are talking about field parameters, you can use bookmarks Power BI- Dynamic Axis- Bookmarks vs Field Parameters https://www.youtube.com/watch?v=cN8AO3_vmlY&t=350...
Re: Error - Formato en el objeto (vista previa) para el tipo de página de obtención de detalles
@RandyPgh , informe también de un problema con las capturas de pantalla https://community.powerbi.com/t5/Issues/idb-p/Issues
Re: Desplazamiento de fecha mediante medidas de consulta directa
@wynhodgkiss , necesita tener una tabla de fechas para que funcione. Puede crearlo en Power BI o en origen. PrevMonth_Sales = CALCULAR ([Ventas],PARALLELPERIOD(Fecha[Fecha],-1,MES)) Debe...
Re: Date offset using Direct Query measures
@wynhodgkiss , You need to have a date table to make it work. You can create that in power bi or at source. PrevMonth_Sales = CALCULATE ([Sales],PARALLELPERIOD(Date[Date],-1,MONTH)) &nb...
Re: Power BI Plan and Capacity
Hi Tom, Appreciate for the prompt response. And yes, all of your assumptions were right. Sorry for the vague terms used here as I am still new to this product. The links you p...
Re: crear tabla de fechas sobre la base de varias tablas
@h_l ¿Ha intentado utilizar CALENDARAUTO() Función CALENDARAUTO (DAX) - DAX | Microsoft Learn