Power BI -tuki

Haku

Copiar grupo de una PBIX a otra

Hola a todos! Tengo un problema que necesito ayuda. Tengo un grupo (vea la captura de pantalla a continuación) en un archivo PBI, esta agrupación tiene una larga lista de elementos y, por lo tant...

Re: How to get percentage?

@mfaisalk  You'll have tomodify the code in the Advanced Editor to add that step. Make sure that you update  #"Changed Type" if necessary to match the name of the previous step allTraff...

Re: Copiar grupo de un PBIX a otro

Lo siento, no puedo ayudarte con eso. La nueva columna tiene la misma funcionalidad que un grupo, pero como mencionó, EditGroup no está disponible. No estoy seguro de qué más se puede hacer.

Re: DAX para el total acumulado requerido Producto y mes

@DimaMD Sí, funciona cuando se toma el valor de segmentación de datos de DataTable. Pero no puedo tomar la forma de segmentación de datos DataTable porque tengo otro elemento visual en la mis...

Power Point Complementary

Dears, I have a problem with power point complementary!   Aflter download the link of power bi on power point complementary, I see that the image is not so good.   There's any solution ...

Viewing changes in historic snapshot reports (urgent)

Hi all, I am looking for some support in visualisng my monthly snapshot reports that are connected to my SharePoint folder.  I have provided a set of snapshot Excel files and I am seeking ...

Re: DAX Help for comma separated values

@krishnanvs -You have written the DAX Little bit correct you just need to do correction in that is this:-  Sum = Var getPlace = SELECTEDVALUE ( 'Table 2' [Place] ) Var g...

Re: Calcular el promedio de ventas por cuenta en un dato sin procesar

Hola Yolo. Gracias por la respuesta. La solución no funciona y esta es la razón: El número de cuentas no debe ser acumulativo. Si en enero eran 5 cuentas y febrero son 6 cuentas, entonces ha aument...

Re: Ayuda de DAX para valores separados por comas

@krishnanvs Como ha sugerido amitchandak, en ocasiones como esta, siempre es recomendable dividir la columna en filas en Power Query. Si sus datos no son grandes e insiste en hacer con DAX, i...

exclude text value from table based on condition

Hi,                 Need help to create the logic for report creation. Above status column value is taken from separte table.There is no relation between the...

Re: Amount of refuel in trip Correct calculation

Hello Dear friend  @tamerj1  I am very happy for you, I thank you for your decision and the time allocated for this. But during that time we achieved the goal ourselves.  ...

Re: Showing historic snapshot reports (urgent)

I have queries for each table I've imported with "date created" columns.    How can I also get my (project, programme, portfolio) filters to link to my appendid query with all the sheets

Re: Need help, on Count if row value repeats, Count number of times value repeats in column

Hi Mahesh,   Thanks for the help, but as mentioned in example, i need the combination of column1 and column 2 repeated.  

Need help, on Count if row value repeats, Count number of times value repeats in column

My dataset is in direct query mode and i wanted to achieve below requirement using power query. In PowerQuery I want to add a custom column that evaluates how often a value repeats. I want to do t...

Power BI Pro workspace can make linked table ?

Hi, I have a workspace with Pro licences, i want to use dataflows? I read some articles and it saids that Pro can only store data into table but cannot make a data model (linked table) like Power De...

Re: Need help, on Count if row value repeats, Count number of times value repeats in column

Hi @Harshi_bi  Here's an alternative to the grouping and merging you do not want. Place the following M code in a blank query to see the steps. let Source = Table.FromRows(Json.Document(Bina...

Re: Mostrar leyendas según el filtro seleccionado por el usuario en el gráfico de columnas apiladas.

Hola a todos, ¿Podría por favor ayudar en esta solución? Todavía no puedo obtener una solución para mi caso. Si alguien necesita un archivo .pbix de muestra, hágamelo saber. Compartiré a través d...

Re: Creating a Table visual in Power Bi

Hello amitchandak, Thanks for replying. But this isn't what I was looking for. This will just create slabs/bins/groups. The particular value is part of a single group. But in the case I am looking f...

Print a symbol whether the value is Significant or not

Hi All, I have build the measure where I got the p-value but I am not able to print the same in required format. I want to show the upward/downward arrow based on two filters one is year filter othe...

Re: Can we maintain unselected values to keep initial table laytout regardless of filter applying?

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 whether it suits your requirement. ...

Re: If statement for greater date

Hi @Rustynom ,   According to your description, here are my steps you can follow as a solution. (1) This is my test data.     (2) We can crea...

Night and Day plot area background

Hi There,   I have a question that i can do in Excel however I am having difficulties on doing it in Power BI.  Is there anyway to make plot area background like this in Power BI? ...

Re: How to get a stepped layout in a Table or Matrix like in the message body

Hi @krishnaHCL ,   You can use "Drill Down" in Power BI. Put the hierarchy into the columns of the matrix and expand all. Below is an example for your reference. Drill d...

Re: Para cambiar el color (dejar en blanco) los valores no seleccionados en gris.

@jeongkim ,La información que ha proporcionado no me aclara el problema. ¿Podría explicarlo con un ejemplo? Aprecia tus felicitaciones.

Re: Data bars

Hi @DeeapkBI    Please check if you have selected "Don't summarize" for Quantity and Profit columns. With "Don't summarize", they will not show "Data bars" option. Instead, select ...