Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago
Solved

Character not showing up

Sometimes the up or down character does now show in service and I am wondering what I can do to fix this. This doesnt happen all the time and it doesnt have any patterns. I have refreshed report mult...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi stribor45 ,

    You can try this DAX:

    Measure = IF([% measure a] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

    Connect the labels directly to the data so that changes to the data directly change the up and down labels and the data

    Best Regards,

    Xianda Tang

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

stribor45's avatar
stribor45
Post Prodigy
2 years ago

this worked for me when I connected the labels to data directly but this brought forward another question.

 

I have 4 different measures  (measures A, B, C and D) and they all have different values (see code below). Is there to shorten this code? It seems redundant and the only difference is the measure used.

 

Measure Show A = IF([% measure a] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show B = IF([% measure b] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show C = IF([% measure c] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show D= IF([% measure d] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

 

 

lbendlin's avatar
lbendlin
Super User
2 years ago

Calculation Groups?