Power BI Support
Search
Re: Valores similares para igualar un valor común
Genial. Gracias. Solo necesitaba agregar una coma entre ... (UPPER(ColA) y "NHP") entonces la fórmula funcionó. Ahora, veré si puedo las próximas condiciones 😉 adicionales Erik
Re: Excel file shows lower value than Power BI
@x-File , Share the screenshot of your data. Thanks, Arul
PowerBI using multiple parameters
I have had a query about amending an exisiting report. Briefly the query is as follows. create a pair of user input parameters, these would be quantities, a decimal number.&nb...
Re: Agrupar por y resumir
Hola de nuevo Es cierto que el diagrama de Gantt no acepta las medidas como entrada a las fechas de inicio y/o finalización. Sin embargo, una solución alternativa es simplemente agregar los cálcul...
Re: el archivo de Excel muestra un valor inferior al de Power BI
Archivo @x , ¿Puede compartir el archivo de datos de muestra? refiera la imagen donde puede agregar sus archivos mientras responde, Gracias Arul
Re: Change in Query name
@Variation_31415 , In the applied steps on the right side, got to navigation step then expand the formula after selecting navigation. Next replace "2023Test" with"2023Final" in the formul...
Re: Classic App vs New Audience app
Hi @collinq - thanks for your help. I have spoken with MicroSoft support who seem to think this is a limitation with the build, which is hugely frustrating. I'm hoping someone w...
Re: How to show "*" as a data label if the value is between 1 and 5 (both ends incl.) in a
I've worked with similar problems before, where its important to suppress certain figures/ counts. In this case you need to create a measure and display it in a table. Suppresse...
Re: Distinct count when count of elements are higher than
Hi @Andrylodra , 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 measures. Mea...
Alerts ,subscription in power bi
Hello all, I have a client requirements , they want power bi service features like 1. data alerts 2. Email subscription 3. Analyse in excel in on premises version i.e power bi desktop. is the...
Re: Filtrar la fecha por los últimos 30 días
Hola En el Editor de consultas, separe la columna Hora de la fecha de finalización. Cree una tabla de calendario y una relación (Muchos a uno y SIngle) desde la columna Fecha de finalización a la ...
Re: does the r or python visuals of power bi appear in the power point extract?
Thank you very much. You saved me a lot of time. I need the double box plot. I didn't find it anywhere. I even asked the question on the forum to know how to create it or if someone knew if ...
Re: format Date
Hi, the settings seem correct
Re: Nombre del producto superior por categoría
Hola, por favor pruébelo: TopProduct = VAR RankingContext = VALUES(DIM_WON_ANALYTICS[Producto]) VAR TopProductSales = CALCULATE([Total Sales], TOPN(1, ALL(DIM_WON_ANALYTICS[Product]), [Total Sal...
Re: Add the value from one article to other articles
@adrian-dumitru It doesn't have to do that. It just need to check whether the current row Article name is part of the name of the article under the iteration inside FILTER. The code is ...
Re: Conversion Tool for MSTR Dashboard to Power BI
Hi @danextian , Thanks for the reply. Creating from scratch was our plan. Just wanted to be sure if there was some other way which we were not aware of. Thank you 🙂 Be...
Re: Nvarchar from view not grouping via dataflow - Status changed to: Investigating
Hi @paivers , It would be great if you could provide more information. 1. Your version of Power BI Desktop 2. What connection mode are you using to connect to your data source?...
Re: Herramienta de conversión para MSTR Dashboard a Power BI
@danextian , Gracias por la respuesta. Crear desde cero era nuestro plan. Solo quería estar seguro de si había alguna otra forma de la que no éramos conscientes. Gracias 🙂 Saludos Prác...
Re: Ayuda con el tamaño de la pantalla en el escritorio para ventanas emergentes
@TimoOhio , Pocos usuarios se enfrentan a esto en febrero de 2023. Hay algunos problemas de opción, consulte - https://community.powerbi.com/t5/Issues/idb-p/Issues
Re: Conversion Tool for MSTR Dashboard to Power BI
There is no conversion tool. We need to create manually each and every report from the scratch. Hope this will help you
Re: Cómo agregar un color diferente para cada barra en el gráfico de columnas agrupadas
@harirao , Puede usarlos usando el formato condicional en la opción FX de columnas. Compruebe esta característica en la actualización de Power BI del 23 de febrero. https://powerbi.microsoft.com...
Re: Help with screen size in Desktop for popups
@TimoOhio , Few users are facing this on Feb-2023. there are a few option issues, refer - https://community.powerbi.com/t5/Issues/idb-p/Issues
Re: Asignado a la columna anterior
Usando =SI(A2="C",0,1) podemos obtener la columna D. ¿Puede sugerir una lógica si solo tenemos dos columnas como C, R en una columna y O,1 en otra columna? Vea la tabla a continuación, Ev...
Re: Sharepoint site file source and else-if calculated field
Hello @anettpb , check if this article would help in your case https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters If ...
Sharepoint site file source and else-if calculated field
Hello Dear Community! I started to get familiarize Power BI just a few months ago and I would like to build a dashboard, which uses excel files from Sharepoint sites which are refreshing in ...