Valor Formatado No Gráfico

[Vilmar]

Olá,

A medida formatada abaixo funciona em uma tabela, mas não em um grafico. Tem alguma forma de corrigir isso?

Medida = 
SWITCH (
    TRUE (),
    AND ( [Receita] >= 1000, [Receita] < 1000000 ), FORMAT ( [Receita] / 1000, "#K" ),
    AND ( [Receita] >= 1000000, [Receita] < 1000000000 ), FORMAT ( [Receita] / 1000000, "#M" ))

[v-yetao1-msft]

Hi @Vilmar 

You can change the units for all the bars not for one of them . The units of all values must be the same .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yetao1-msft]

Hi @Vilmar 

I don't quite understand what you mean by staying on the label of the icon ? Show the value on the bar graph ? If this is the case, just turn on the Data Label option in Visual Format function.

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vilmar]

@v-yetao1-msft é quase isso, mas repare que em 2021 o valor é 0,52M e não 524K

[v-yetao1-msft]

Hi @Vilmar 

Is this the result you want ? The column [Medida] I created is a calculated column with the formula you provided ,and I put it in Legend in Column Chart .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vilmar]

@v-yetao1-msft obrigado pela resposta.

Mas preciso que fique no rotulo no grafico.