Forum Discussion

crjackson's avatar
crjackson
Helper I
3 years ago

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