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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi stribor45 ,

You can use the Reference labels in the new card visual object to add labels for your four measures, and then you can modify its color according to the appropriate rules.

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

I know but to use that I have to create a new measure and use that instead of the original value [% measure a] which is now text and not a number anymore. That's what I was trying to avoid because it caused me a problem of Unicode not rendering in service. Looks like that is my only option anyway to change the colour