Forum Discussion

hobosapien's avatar
hobosapien
Icon for Helper I rankHelper I
1 year ago
Solved

Adding % format to card visual measure with conditional formatting

I have applied conditional formatting to a measure that's being used in a basic card visual. However, if I attempt to format this by enclosing the measure in FORMAT() the conditional formatting doesn't like that it is now in a text type instead of a number. How can I simultaneously format this to show as 95.85% and have conditional formatting at the same time?
 
Measure: AVG EVAL = CALCULATE(AVERAGE(f_EvaluationScores[Score]),FILTER(d_Dates,d_Dates[Year]=2024))

 

Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi hobosapien 

    Question: why is your measure more than 1. If formatted to percentage that would be 9585% and not 95.85%. That aside, select the measure and then format it to % from the contextual tab that will appear. Also, if you need to show 95.85%, modify your measure to this:

    AVG EVAL =
DIVIDE (
    CALCULATE ( AVERAGE ( f_EvaluationScores[Score] ), d_Dates[Year] = 2024 ),
    100
)

     

     

4 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi hobosapien 

    Question: why is your measure more than 1. If formatted to percentage that would be 9585% and not 95.85%. That aside, select the measure and then format it to % from the contextual tab that will appear. Also, if you need to show 95.85%, modify your measure to this:

    AVG EVAL =
DIVIDE (
    CALCULATE ( AVERAGE ( f_EvaluationScores[Score] ), d_Dates[Year] = 2024 ),
    100
)

     

     

    • hobosapien's avatar
      hobosapien
      Icon for Helper I rankHelper I
      1 year ago

      Ah - I see. I was selecting the card and thinking the % formatting should be there, but I needed to select the measure instead and that's where I went wrong. Thank you for the other suggestions too.

       

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        1 year ago

        There is visual level formatting available in the card as well. This will override the semantic-model wide formatting applied to the related measure.

         

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    Hi,

    Just select the measure and click on the % age symbol button in the ribbon.  Furthermore, you can simplify your measure to:

    AVG EVAL = CALCULATE(AVERAGE(f_EvaluationScores[Score]),d_Dates[Year]=2024)