Power BI Support
Search
How to make a Reset button for synced slicer?
I have slicers on all my tabs and all of them are synced. The problem is, if i forget on which page I used the slicer first, the reset button doesn't work to reset the filters set on other pages. I ...
¿Cómo hacer un botón Reset para la segmentación sincronizada?
Tengo segmentaciones de datos en todas mis pestañas y todas están sincronizadas. El problema es que, si olvido en qué página usé la segmentación de datos primero, el botón de reinicio no funciona par...
How to fill up/down the blanks in a calculated column of data model (Not in Power Query)
All the dates after 1sy July-22 shall have 1st july -22 . THis is a lookup value column in an crossjoin table.
Re: Cómo rellenar los espacios en blanco en una columna calculada del modelo de datos (no en Power Query)
@MaulikG7 , tenemos que crear una nueva columna. nueva columna = var _max = maxx(filter(Table, Table[Date]>= before([Date]) && not(isblank(Table[Code])) ), [Code]) devolución ...
Split Column to Text Values and Number Values
This is slightly different than splitting a column by first instance of text of number. I have a column whose values are EITHER Text or Numbers. Eg. AAA BBB 123 456 How do I ...
Re: Contar filas totales de "Met"
@pitcraj Agregue una nueva medida con la fórmula siguiente: Count_Met = CALCULATE(COUNTROWS(Test),Filter(Test, [Status(Measure)]="Met"))
Re: Count Total Rows of "Met"
@pitcraj Add a new measure with the following formula: Count_Met = CALCULATE(COUNTROWS(Test),Filter(Test, [Status(Measure)]="Met"))
Re: Sort and Unblock filter pages in PBI
@DR2022 , I doubt that, You need to put them in order of display. Block unblock you can do with a slicer, not with filters. refer video from Guyinacube -https://www.youtube.com/watch?v=sXn-QZqLD-8
Re: Sort and Unblock filter pages in PBI
Great! I'm going to test here and then I'll give you feedback. Power BI is the same as Excel. There's always a new trick you can do. Thank you very much!
Re: Dashboard Inventário
Seu arquivo ficou perfeito, bem objetivo e de fácil entendimento. Se não se importar (claro), poderia compartilhar o arquivo .pbix para ver como você fez? Se sim, segue meu e-mail: kleibercf@h...
Re: ¡Urgente! No hay conector web disponible para Jira
Hola Consulte este vínculo que puede ayudarle a conectar jira a Power BI https://www.youtube.com/watch?v=fdM-t2YaFiQ Si respondí a su pregunta, marque mi publicación como solución para que ap...
Re: SAP BW - How to write conditional M statement to pass a range of values as a parameter
Hello, thank you for the suggestion. I am not familiar with writing MDX queries - do you have any specific guidance on how I might write the query for what I would like to accomplish?
Date Visual Randomly Reformatting
Hello, I have a visual that records my organizations reviews, into good and bad, and then the net number of good reviews over time and I want it to be set to a date hierarchy, with only the ...
Re: Suddenly Border displayed on the slicer in the workspace
Same here! It appears to have happened after the last system upgrade (Dec service launch.)
Re: Power Query : customize column that count number of rows for each ROW
If I understand properly, you can do this in PQ by Group by Product Key Count the number of YES in each group Re-expand the table Note that your example seems to be incorrect 31/2/2000 is not...
Re: Calculate till date marketing cost per publisher using fixed rate card for each conversion type
You probably will need to normalize the second table into publishers and rates. It is not clear how you compute rates with both exp_bucket and campaign_type. Please show the expected...
Re: Crear una tabla de partes de horas que falta
Hola Chris, así que usé tu alma y funciona muy bien, sin embargo, quería refinar esto aún más. Para que los datos fueran útiles, quería agrupar los días por semana. Sin embargo, para cada semana, la ...
Re: ¿Contar la animación en la tarjeta?
Eso solo le muestra los valores para cada fecha específica. No acumula el total acumulado a lo largo del tiempo.
Re: Creating A Missing Timesheets Table
Hi Chris so I used your soultion and it works great, however I wanted to refine this further. In order for the data to be useful I wanted to group the days by week. However for each week, the measure...
Re: Date Range slicer start date and end date to custom dates
Hi, Create a Calendar Table with this Table formula Calendar = calendar(min(table[date]),max(table[date])) Create a relationship (Many to One and Single) from the Date column of Table to the Da...
Re: Measure to calculate the standard deviation
@MostafaGamal That should just be STDEV.P or STDEV.S: STDEV.P function (DAX) - DAX | Microsoft Learn
Re: Matrix with Clustered Bar Chart
You could likely create that visual with Deneb by using hconcat to combine the bar chart and matrix, and then using facet to create that for each question. Getting Started | Deneb Pat
Re: Tamaño de fuente (mínimo) de PBI y servicios relacionados
@QC , El tamaño mínimo del texto en Power BI es actualmente de 8 pt. Aquí hay una idea para permitir fuentes más pequeñas. Asegúrese de agregar su voto. Saludos Equipo de Apoyo a la C...
Re: The inserted shape with "Web URL" action doesn't work in Power BI mobile app
Hi @bergen288 , According to your error description, you can open the Web URL link button normally on your PC, but touch the Power BI Home box in Power BI mobile app on my iPhon...
Re: Measure to display value based on amount conditions
@DimaMD Thank you for your reply. But, I didn't see the conditions about this: The measure will display "GREEN" if: - RESULT is "pass" The measure will display "RED" if:...