Power BI Support
Search
Re: Min give error due to blank or empty value
I think you have an error because the type of data you get with measure is different but this power bi doesn't support. write like this = if( values(Mastermaterialsap[DChain-spec.])="E51", ...
Difference in data for analyze in excel and power BI
Hello , I am facing a data validation issue in analyze in excel and power BI dashboard. Below is BI dashboard % distribution weekwise. When same data i am analyzin...
Create Calculated Column for Slicer use
Hello, I have a table that I want to create a calculated column (I think this is what I want?) so that I can use it as a slicer. I have records in my table that have Division and th...
matrix data bars conditional formatting
sample format: issue: i cant figure out how to format the data bars for the totals and subtotals sections (circled in red) not sure if this is possible or missing a step. thank you!
Realizar cambios en el modelo de datos mediante la actualización incremental
Estoy usando la actualización incremental para una de las tablas de mi modelo, ya que esa tabla es grande y tarda más de 5 horas en actualizarse. Mi preocupación con el uso de la actualización incre...
Scorecards Checking in After Due Date has Passed
Hi everyone, Does anyone know if there is going to be future implementation for tracking scorecard metrics with a hard due date? For example, suppose I have made a scorecard for a s...
Re: Issue aligning last year and current year weekend dates.
Hi @pratikm1354 check link https://www.daxpatterns.com/week-related-calculations/
Re: Conditional formatting table based on a target set
I already added the link for a testing pbix file into my original post yesterday, but forgot to mention it in the previous post. I use this formula that works for me now: MgCheck = V...
Fabric Data Factory Pipeline: Incremental load
How can I create an incremental load in Data Factory Pipeline? I only see the Table Actions append or overwrite. But I want to be able to add new rows, update existing ones and mark del...
Known issue - GetVisuals() API for custom visuals may return a blank title - Power BI
A known issue is posted where the GetVisuals() API for custom visuals may return a blank title
Filtro de tabla (por favor ayuda)
Hola Necesito ayuda para aplicar un filtro de tabla, ¿por favor? Si "OT $ Claimed" es 0/null && "Allowed OT $" es 0/null, entonces debe filtrarse fuera de la tabla. No quiero ver cuándo "O...
Re: Can't assign workspace to domain
I've updated the original post with images.
Re: Mensaje de error: No pudimos autenticarnos con las credenciales proporcionadas.
He probado la cuenta de Microsoft. No funciona. Dice que ya has iniciado sesión y sigue mostrando el mismo "No pudimos autenticar...". Un minuto la conexión funciona bien y al siguiente deja de f...
Re: Status 400 Error when setting up an SQL Gateway on Power Bi
Hi @GilbertQ Running the latest version of the Data Gateway Software 3000.174.13 (May 2023). The username used has full access to the database. Just to be sure I logged in to the on Prem SQL ...
Re: Base On Min Date on Slicer Filter
Change your slicer type to "Before"
Re: Problemas con Rankx, Dense
Hay algunos desacuerdos leves con su clasificación deseada, pero esta fórmula es lo suficientemente buena: Rank = rankx(filter(ALLSELECTED('data (4)'),not ISBLANK([Value])),[Value]+VALUE([RECI...
Re: Duplicated lines in Matrix table with 2 level Hierarchy when "Show items with no data"
hello! @lbendlin direction is changed, but still have the same issue I shared the data model via link , maybe it will help more to understand the model. I have two dimension tables...
Re: Can't assign workspace to domain
I'm using Edge.
Re: Conditional Colour Formatting using 2 different columns in the condition
Read about ISINSCOPE and adjust the measure accordingly. You may also need to use SUMMARIZE if you want to filter up.
Re: Stacked Area Chart Sort is reversed from what is should be
Also it is not a limitation of the software, this is false. This fix is about as easy a task for a software producer to fix as you will ever see requested in these types of forums.
Re: Power Query - Replace Formula Operator with Parameter
Hi @wdx223_Daniel , Thanks for this. I've tried it on this simple version and it works. But now I'd like to try it with something a little more complex. Here's the original query s...
Text cut off in Power Query Editor when imported from Excel
Hi there, I am having an issue where text that exists in an Excel file (used as a data source) has parts of the text cut off in the Power Query Editor window. Specifically, I am referencing ...
Re: Calcular el pronóstico de ingresos en el año calendario actual
De nada. Alguien más te ayudará con esto.
Re: ISSUE: data refresh linked Excel-files on Sharepoint-site is flawed
Hi @hulsbergenw Your data is stored in SharePoint, so it will excute OneDrive refresh, If you edit the .csv file in OneDrive, or SharePoint, after you save, those changes ...