Forum Discussion
Percent measure in switch function
Hi Guys,
My measure varSelecao = 2, [_EP]*100 is of the percentage type, but in my visual it does not appear as a percentage. Is there any way to adjust this?
Medida Switch Repasse (qtde) =
VAR varSelecao = SELECTEDVALUE(Tabela[ID])
RETURN
SWITCH(
TRUE(),
varSelecao = 1, [_IPC],
varSelecao = 2, [_EP]*100,
varSelecao = 3, [_IPG]
)
- Anonymous3 years ago
Hi kasife ,
Here I suggest you to refer to below solved post which has similar issue like your.
For reference:
SWITCH or VAR Function for multi-data types in single table for rows and columns?
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- AnonymousNot applicable
Are you using Medida Switch Repasse (qtde) in your visual?
If yes, then you need to make this Measure also Percentage type, and that will fix your issue.- kasifeHelper V
Anonymous
Within the Switch, only this measure is a percentage, the others are not. If I change the type, they will all be as a percentage.
- AnonymousNot applicable
Hi kasife ,
Here I suggest you to refer to below solved post which has similar issue like your.
For reference:
SWITCH or VAR Function for multi-data types in single table for rows and columns?
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.