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 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?

      • stribor45's avatar
        stribor45
        Post Prodigy
        2 years ago

        I saw that but that requires downloading new software etc for only 4 measures. 

  • stribor45's avatar
    stribor45
    Post Prodigy
    2 years ago

    this is good and it works in service but the problem is that you can apply the conditional formating rules since this is of type text. i need to apply colors as well to this

    • 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