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 is missing. I have 21 conditions and i am able to see only the first few 😞

Please help me with this.

 

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.

6 Replies

  • 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 🙂

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

    Krishya25 I would surely report this as a bug but my recommendation would be to create a measure and put color condition in that and use field value in conditional formatting, it will be easier to manage and scalable

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

    Krishya25 yes you can use HEX code for sure, make sure to add the # sign with hex code like "#FFFFFF"

     

    Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡