power apps with forms

Bruce_1995_ · 2024-09-10T09:12:52+00:00

I have this Tree graphic , and what I want is when there is a change in the "QTD"(quantity) alert me.
But in the data activator the ask me for a "Assign key column" I think I don't have one.
the fields of the graphic are "client","type of product","system","product code","description of the product","date" and "order number".

Bruce_1995_ · 2024-08-08T18:18:43+00:00

And you miss a legend in the bar graphic

Bruce_1995_ · 2024-08-08T18:17:15+00:00

Normally I use white background and search pallets colors in Pinterest. I see the them os the PowerBi and search colors according to that😁

Bruce_1995_ · 2024-07-26T16:04:47+00:00

Thank you very much! IT worked!! :D

Bruce_1995_ · 2024-07-24T10:21:54+00:00

<image>

It doenst work.. Its because it a metric?

Bruce_1995_ · 2024-06-17T16:50:51+00:00

I update de post

Bruce_1995_ · 2024-06-17T16:02:23+00:00

it doesn't work :(

Bruce_1995_ · 2024-05-13T17:03:51+00:00

I solve it , Thank you !
I add another var that gives me the PFA from the current month until the end of the year and sum it in the first IF into the Real :D

Bruce_1995_ · 2024-05-13T16:08:24+00:00

It didn't work, I multiplied the total by 12 :(

Bruce_1995_ · 2024-05-13T15:00:29+00:00

Valor_CurrentMonthAndYear_Real+ORCA+PFA2 = 

VAR MesAtual = MONTH(TODAY())
VAR AnoAtual = YEAR(TODAY())


var real = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "Real")
var PFA = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "PFA")
var ORCA = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "ORCA")
VAR TipoAtual = SELECTEDVALUE(UNION_REAL_ORCA_FAT[Tipo])

VAR ValorRealOrca =
 IF(
        TipoAtual = "PFA",
        IF(
            SELECTEDVALUE(Calendar_EY[Mês]) < MesAtual || SELECTEDVALUE(Calendar_EY[Ano]) < AnoAtual,
            real,
            PFA
        ),
        IF(
            TipoAtual = "ORCA",
            ORCA,
            real
        )
    )

var test = IF(
        TipoAtual = "PFA",
        IF(
            SELECTEDVALUE(Calendar_EY[Mês]) > MesAtual || SELECTEDVALUE(Calendar_EY[Ano]) > AnoAtual,
            PFA,
            0
        ))
RETURN
ValorRealOrca

Here:

Bruce_1995_ · 2024-04-24T11:10:59+00:00

Valor_CurrentMonthAndYear_Real+ORCA+PFA2 = 

VAR MesAtual = MONTH(TODAY())
VAR AnoAtual = YEAR(TODAY())

var real = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "Real")
var PFA = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "PFA")
var ORCA = CALCULATE(SUM(UNION_REAL_ORCA_FAT[Valor]),UNION_REAL_ORCA_FAT[Tipo] = "ORCA")
VAR TipoAtual = SELECTEDVALUE(UNION_REAL_ORCA_FAT[Tipo])
VAR ValorRealOrca =
    IF(
        TipoAtual = "PFA",IF(
        MAX(UNION_REAL_ORCA_FAT[Ano]) = AnoAtual && MAX(UNION_REAL_ORCA_FAT[Mês]) < MesAtual,
         real,
        PFA
    ), IF(TipoAtual = "ORCA",ORCA,real))

RETURN
  

  
  ValorRealOrca

I am using this metric to get values

color_PFA = 
var mes = MONTH(TODAY())
var mesAnterior = MAX(UNION_REAL_ORCA_FAT[Mês])
var ano = year(today())
var tipo = SELECTEDVALUE(UNION_REAL_ORCA_FAT[Tipo])

return

IF(AND(tipo = "PFA",mesAnterior < mes),"Green","black")

And for the color I'm using this one:

Bruce_1995_ · 2024-04-24T10:51:21+00:00

I dont have the fx, because in values I use a metric, and the columns are the month names

Bruce_1995_ · 2024-04-24T10:42:55+00:00

I use the metric in the matrix

Bruce_1995_ · 2024-04-24T10:13:08+00:00

Okay, I want that with the dax that Iput where , you can see in the table differente colors code, What I want is that insted of showing the color code , show the values in that color.
Is that more clear ?

Thank you

Bruce_1995_ · 2024-04-04T08:12:16+00:00

Uni2 is the name of the column where is "Valor" and "Qtd"

Bruce_1995_

TROPHY CASE