Power BI Support

Search

Permission issue

I'm wondering if it's possible to revoke permissions for only one report. I have an existing workspace that already has access for users, and I've added a new report, but I don't want those users who...

Re: I want to display last 5 years sales when i select one year

Hi Danhe, I have almost similar requirement but its based on the date. Say I select todays date 22 Feb 2023 in slicer then I should get last 5 years data (including quarters,months,dates) based on s...

How to count the column that contain strings Month

Hi,   I would like to count row that contain month January, then feb and so on. However the data that i have is not structured. Some are January. Some are January- February. Any shortcuts? ...

Uso del año fiscal para mostrar la fecha del calendario con el período anterior del año pasado

Hola a todos, Tengo un gráfico que muestra el monto de la colección por año / mes con la cantidad del período anterior y la variación porcentual como una línea. Ahora necesito cambiar la fecha d...

Re: Data Type Changing When Report is Published (Text to DateTime)

Self solved this one.   Issue was being caused by the data type in Excel!  I knew I was missing the obvious.   Leaving this here in case it helps someone else.  

Reports sharing

There are currently two things that I need to clarify at the moment.   - Can I access on mobile app of PowerBi that has free licence a report published by the person with PPU license? - Can w...

Re: Wanted help to understand DAX with selection criteria

@amitchandak @olgad @GuyInACube @Sahir_Maharaj @Greg_Deckler 

Re: Row Count value assigned to Previous Row

Hi @sivasrao ,   Firstly, I think you need to add an index column in Power Query Editor. Then you can create a calculated column by below code to achieve your goal. Target = V...

Re: Valor de recuento de filas asignado a la fila anterior

@sivasrao , En primer lugar, creo que debe agregar una columna de índice en el Editor de Power Query. Luego puede crear una columna calculada mediante el siguiente código para lograr su objet...

Re: Problem connection Power BI to MySQL data source

I'm facing the same problem. Can someone help?

Re: Text Analytics using Machine Learning Python Script in PowerBI

Hello,   Still i did not find the solution for that.   Thanks

Re: For 0 and Blank value matching returns the true value but want to consider false.

Hi You need to take into account that the blanks are being treated as zeros in your comparions. One way to do it is with the ISBLANK() function. A solution could be a calculated column like this: ...

Re: The table no visible columns and cannot be queried

The error message "The table has no visible columns and cannot be queried" typically indicates that the table that you are trying to query in your report does not have any visible columns. This could...

Permiso para establecer datos

He creado un informe de Power BI con objetos visuales de conjunto de datos y front-end. He publicado el informe en un área de trabajo y puedo ver que los miembros del área de trabajo tienen acceso ta...

Re: PowerApps Visual Stuck on "How to get started"

I am not sure it will help, I have existing canvas, with fields, that stopped working this morning, without any changes. See: https://community.powerbi.com/t5/Desktop/PowerApps-Visual-Issue/m-p...

Re: wrong Month values showing

You're very welcome. Glad it worked 🙂

Re: Wanted help to understand DAX with selection criteria

@sbm_tekade  You cannot achieve this using a calculated column. Columns never reference the value of a slicer, as they are already precalculated before the slicer selection: https://excelwi...

Re: Uso compartido de informes

@hezheron 1) No, necesita PPU para acceder al informe publicado en el espacio de trabajo PPU, o Pro para acceder al informe publicado por el usuario con PPU en un espacio de trabajo Pro. Incluso e...

Re: Cuestionario de Personal en planta

Hi!   It looks so amazing!! Can you share me the pbix file into brais.cgaldo@udc.es?   Thank you so much!

Extraer datos específicos de una cadena incoherente en una nueva columna

Hola a todos Necesito extraer algún texto específico de una cadena para usarlo como referencia futura, el problema se debe a que los datos recibidos no son muy consistentes, he intentado usar la ...

Re: DAX formula to filter fact table from dim table

Hi @Idrissshatila . Thank you for your reply.   The relationship is active as below with both data types being whole number.   With the formula Count of overall e...

Re: Información sobre herramientas: mantener el nombre de la leyenda

Hola, crea una medida min(ProductCategory) Agréguelo como una tarjeta a su información sobre herramientas para que se muestre en la parte superior, digamos. no olvide colocar su categoría de nivel ...

Re: DAX IF OR Measure no funciona según criterios

@apple1111 ¿En qué contexto visual estás tratando de usar esto? Intente cambiar el valor SELECTEDVALUE a max y vea si eso le da un resultado, entonces debe comprender qué está haciendo, ya que puede...

Re: Usage Metrics Report does not show Page Views

Facing same issue starting this month, did we have any solution for this issue.

Re: 'LocalDateTable' with ShowAsVariationsOnly property set to '1' must be a target of variation....

Hi I had the same issue, solved it by going to Transform Data / Data Source Settings Then for each Direct Query link to PowerBI Datasets I clicked change source, (then just clicked confirm with all ...