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 does...
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
)

     

     

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.