Forum Discussion

Krishya25's avatar
Krishya25
Frequent Visitor
5 years ago
Solved

Vertical Scroll bar not available in Conditional Formatting popup window

Hello Team, I am working on a long list of condtions in the conditonal formatting and recently i had a add a new condition to the existing list of conditions and noticed that the vertical scroll bar...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Krishya25 sorry, missed giving an example of a measure

     

    Color Measure = 
SWTICH ( SUM ( YourTable[YourColumn] ),
1, "Red",
2, "Green",
3, "Blue",
4, "Yellow",
"Black"  --else 
)

     

    and use this measure in conditional formatting, and in the future, if you need any change, you can simply make a change in this measure instead of dealing with conditional formatting conditional screen.

     

    Just a suggestion.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Krishya25 sorry, missed giving an example of a measure

 

Color Measure = 
SWTICH ( SUM ( YourTable[YourColumn] ),
1, "Red",
2, "Green",
3, "Blue",
4, "Yellow",
"Black"  --else 
)

 

and use this measure in conditional formatting, and in the future, if you need any change, you can simply make a change in this measure instead of dealing with conditional formatting conditional screen.

 

Just a suggestion.

  • Krishya25's avatar
    Krishya25
    Frequent Visitor
    5 years ago

    Thank You parry2k , It is a good suggestion. Intead of the color name can i use the rbg or hex code in the SWITCH measure.

  • Krishya25's avatar
    Krishya25
    Frequent Visitor
    5 years ago

    Thanks for the idea actually using Switch in the measure is much easier than using the conditions. As the same measure is used for both the Background and the font colour. No duplicate effort is required. i just love it. Thanks a lot 🙂