Vertical Scroll bar not available in Conditional Formatting popup window

[Krishya25]

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.

[amitchandak]

@Krishya25 , You should be able to scroll with Arrow. 

For scrollbar you can log and issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

Also as suggested by @parry2k , you can use a color measure field value option 

[parry2k]

@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.⚡

[parry2k · Accepted solution]

@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]

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 🙂

[Krishya25]

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.

[parry2k]

@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