Suporte do Power BI
Pesquisar
Re: Change Date format to MM-dd-yyyy from mixed datatypes in Attribute column
Hi, @Sejal After testing, the date and text column format in the same column will be unified as Text. You can format dates, but text cannot coexist. Unfortunately, th...
Troubleshoot reports: Map reports in a Power BI paginated report - Power BI
Explore troubleshooting ideas for situations that can result when you customize, add a layer, or publish a paginated report with a map in Power BI Report Builder.
Re: Cálculo de horas extras pagadas y no pagadas
@mo1988 ¿Puede proporcionar el resultado de la matriz visual u otros datos de muestra, Es el " [TotalHours]" una medida? ¿Qué función tuviste? ¡Saludos! Yolo Zhu Si esta publicación ayuda...
Re: Error while refreshing data
HI @alpha_123, Current power query table field does not support store multiple type of values in the same field at the same time. Have you check the source data to confirm if any excepted stri...
Re: Help with my dax
My bad, "There is no active relationship". so that couldnt use "related" function. I am looking for a solution for fields that are both created as a calculated column in Power bi and fields ...
Combine data
Currently my data are being stored as 2 seperate line as sample below. How can I move the ID from row2 to new column so that it become single line? Thank you.
Re: Transformación para este tipo de tabla
@chinaik123 Puedes hacer lo mismo decir A continuación, puede dividir la columna para obtener el año y el mes Por favor, vea el archivo adjunto a continuación
How do I sort the breakdown in Waterfall chart in PBI based on Months and not on values?
I have added Start and End Bar using switch conditions and the breakdowns are dynamic (Can't be fixed in Switch statement). I want the breakdowns to be ordered based on Month order not on increasing ...
Calcular la suma de horas desde el otro tabel entre hasta las fechas
Hola. Tengo 3 tabels 1 calendario 2 Empleado 3 Absentismo En mi calendario, tengo las horas estándar por día. En mi ausentismo tengo un StartAbsenDate y StopAbsenDate Quiero calcula...
Need Power shell script to know what are the power bi dashboard using by user
Hii Thanks in advance .I need the script to know what are the power bi dashboard using by user .
Calculate sum of hours from annother tabel between to dates
Hi. I have 3 tabels 1 Calender 2 Employee 3 Absenteeism In my Calender, I have the Standard Hours per day. In my Absenteeism I have a StartAbsenDate and StopAbsenDate I want to c...
Re: Transformación para este tipo de tabla
@ryan_maju, Lo siento, cambio mi muestra para agregar en el año como dejé fuera anteriormente. Esta es la muestra y estoy tratando de obtener algo similar a ti. Sin embargo, cuando despivoto y hago...
Re: Dynamic union queries based on list of DB names
Hi there, Sure. This can probably be done a bit cleaner than what I did. But here you go (comments in the code). let // Define a parameter named "DatabaseList" that contains a...
dax | to maintain measure values while stil changing the period visual slicers
hi, i have managed to get a measure working for the latest date as follows. Ar-Act-LD = VAR LatestDate = [LastTransactionDate] RETURN CALCULATE ( ...
Re: JSON Theme: Parámetro para establecer el esquema de la casilla de verificación de Slicer
Desafortunadamente, esto no ayudó, ya que no creo que la interfaz de usuario ofrezca la posibilidad de cambiar el color del esquema.
Re: How do I verify the content of a column based on a number of most frequent values?
My goal is to create a measure that writes a 1 or 0 in a separate column. Measure function: Filter out all employees from a project who are not in the same office as the project manag...
Re: Sorting in Treemap chart
Yes @Ahmedx exactly like this! 🙂
Cómo crear un conjunto de datos compartido de Power BI desde una aplicación web
Hola Hemos planeado almacenar algunos detalles de configuración de Power BI en nuestro archivo de configuración de la aplicación web. Desde ese archivo de configuración leeremos los datos y necesita...
Re: Icono url que no aparece en la tabla
gracias, funciona eso me faltaba
Unique list values in filter and when multiple values selected should filter comma seperated entry
i have a list of tags some of which are comma-separated as shown in the image below when I use the same column in the filter it shows comma-separated entries as well as shown b...
First transaction of the week by customer - calculated column
Hi everyone, I am wanting to create a calculated column where I want to locate the first rowcount of the week for every individual customer, and mark it with a "0". Then for all other counts till the...
The report is showing old value even after incremental refresh
Hi Team, We have a dataset with import mode tables, we have added incremental refresh on the fact tables. when we execute the report one of the measure is still showing old values, whereas t...
Re: Elimine el nombre de encabezado de fila vacío de la matriz que tiene 2 medidas diferentes.
Lo siento @Idrissshatila pero no funciona
Re: Elimine el nombre de encabezado de fila vacío de la matriz que tiene 2 medidas diferentes.
Hola @Swapnil_Palekar , Intente filtrar la medida para que no se muestre en blanco desde el panel Filtro Si respondí a su pregunta, marque mi publicación como solución para que apare...
Re: Help with Time Intelligence using Fiscal Years
hi @Isnaan_Ahmed try like: _OrderedUnits Last FY = VAR _SelectedFY = SELECTEDVALUE ( _FiscalDates[Fiscal Year (544)] ) RETURN CALCULATE( [01. Ordered Units], _Fiscal...