Forum Discussion
crjackson
3 years agoHelper I
Formatting String - Percentages
Hello!
I am working with the new dynamic formatting for measures. I am trying to format the bold section below as a percentage with no decimal places; however, it isn't picking up the zeros. I would like them to say 0%. is there a way to fix this?
VAR _Measure = SELECTEDMEASURE()
return
SWITCH(
TRUE(),
_Measure = [Total Metric], "0",
_Measure = vw_CNMetrics[Metric% average per Month], "0%")
1 Reply
- baghdadi62Resolver III
Hi,
Have you used the Format() function?