Power BI Support
Search
Re: Report warning/Error message in the report
Hi @Nisha02 , Based on your description, you need to get a prompt when a refresh fails. You can refer to the following links: Data refresh in Power BI - Power BI | Microsoft ...
Re: Data modeling help with related records
Hi @Arete , Ranking measures is currently not possible because measures are data generated in real time. You can try clicking sort and then reading the top 10 names. &...
Re: DAX Query
Hi @gadlakha , Plese try this: LastRelId = CALCULATE ( MAX ( 'Table'[ID] ), FILTER ( ALL ( 'Table' ), 'Table'[isRelease] = TRUE () &&am...
Re: Actualizar datos con la plantilla PowerBi
@darrylwjk PowerShell funciona en los datos de ejemplo y se crean los pasos de concordancia. Si ya tiene datos de ejemplo, puede ejecutar su código en ellos para verificar si no hay errores en el cód...
Power BI Desktop - brak danych na mapie
Szanowni Państwo, proszę o informację dlaczego gdy jestem zalogowany w Power BI Desktop to nie widzę danych na Wizualizacji Mapa, a gdy się wyloguję to widzę. Z poważaniem Aleksander Gruszewski
Re: How to add borderline for each row in clustered bar chart
@nuhasan You cannot actually add gridline on Y axis. Regarding an alternative... I will suggest Ribbon Chart which I like how it shows trend over time. You can see ...
Re: Contar el número de ocurrencias en cualquier hora dada usando DAX
@PAD , Por favor, intente: Primero cree un parámetro: A continuación, aplique la medida: Measure = CALCULATE(COUNT('Table'[Time]),FILTER('Table',HOUR([Time])=SELECTEDVALUE(Param...
Re: sorting columns
thank you all i have fixed the issue
Re: Switch function based on selection filter to another table value
Hi, To overcome this error, you may also use FILTER function instead of direct filter expression. Filteration in measures does not work directly in expression, but works with FILTER function. ...
Re: Count the Number of Customer Order in Current Month vs. Last 03 month
hi @ADSL try to 1) get a customer list from Aug to Oct, like CALCULATETABLE(VALUES(), FILTER(...)) 2) get a customer list in Nov 3) make an EXCEPT of the two If ...
Re: Issue with text values conditional formatting in matrix visual
Thanks for you quick response @amitchandak , but my query is different, i have 2 tables and i need to compare the text valuesb/w both tables and those changes need to highlith in live sheet...
Re: Comparar dos fechas y crear una nueva columna con la más reciente de las dos fechas
@PBrainNWH , ¿Cuál es la relación entre las dos tablas, proporcione datos de muestra y resultados esperados? Consulte los siguientes enlaces: Cómo proporcionar datos de ejemplo en el foro d...
Re: Measure with no Total
Hi @cbrickman , 1.Try to add an additional measure as follows. Measure 2 = SUMX ( 'Table', [Measure] ) 2.You can use SUMMARIZE() to deal with. Below is the similar p...
Re: All potential values for filtering
Hi @ibanezpi , I'm a little confused about your needs, Could you please explain them further? Thanks for your efforts & time in advance. Best regards, Community Su...
Re: Duplicate records in thin report but not in the dataset
Who accepted my comment as a solution? It's not resolved and my comment is not the solution. I still have duplicates after having done the procedure I mentinoed above.
Re: Calcular el total general
@Mathieu75 , Asegúrese de dónde están las columnas del mes en su visualización de línea. Intente medir como se muestra a continuación. Mix CPNL 2021 = SUMX ( VALUES ( 'TableName'[Month] )...
Re: Calculate Grand Total
Hi @Mathieu75 , Please make sure where is month columns from in your line visual. Try measure as below. Mix CPNL 2021 = SUMX ( VALUES ( 'TableName'[Month] ), [CPNL 2021...
Re: How can You transform data in Power BI Desktop Excel as it is showing correct in power Query Edi
So basically the formatting and calculations needed to be updated like cells were taking formulas instead of values... got this resolved thanks!!
Re: Crear nueva columna con ID anterior
@Omelei Intente agregar la columna con esto: Custom Previous Opportunity ID 2 = VAR _id = [Account ID] VAR _date = [Startdate] VAR _table = FILTER( data, data[Account ID] = _id ) VAR ...
Re: Accessing HTML table Data through API using Power Query
Hi @hana123 , Yes, it is possible to create a dashboard in Power BI that allows an employee to enter their employee number and displays their information in a table. Here's one w...
Re: Quiero mover la posición de la columna en una tabla de matriz
Vea mi respuesta aquí https://community.powerbi.com/t5/Desktop/Add-same-value-into-multiple-quot-data-groups-quot/m-p/2991519#M1021557
Re: Resaltar el valor máximo en un gráfico
Lo convertí en allselected y no funcionó Puede encontrar en el archivo de muestra en el enlace Gracias https://drive.google.com/file/d/13S9q0S0oWovbeIbM0lwFLfDgsJFPCsz3/view?usp=sharing
Re: Refresh Web source through power bi server web portal
yes. worked and conneted in power bi desktop using Anonymous
Re: measure rolling 12 month average (returning blank when there are not enough months)
Dear @Greg_Deckler , Thanks a lot for your reply, this is indeed a better way to create a moving average. I was wondering how I modify this dax to not return a value/ ...
Re: Highlight the max value in a chart
TotalPRF = CALCULATE ( COUNT ( PRF [INTNR] ))