Solved: Conditional Formatting - background color

sraizada · ‎09-19-2019

Hi All,

Some options are not showing up in my Power BI version.

For instance in the background color formatting options, the color based on and summarization field is missing.

This is what I have available:

Its only recognizing red and green and not the range set up for yellow. The reference field is a measure. Any ideas I could have it to work for all three colors.

thank you

v-shex-msft · ‎09-20-2019

Hi @sraizada ,

Based on my test, I found these options will disappear when you try to use feature to analytics measures. It only works on static table fields and calculated column.(measure not support aggregate)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎09-20-2019

Hi @sraizada ,

Based on my test, I found these options will disappear when you try to use feature to analytics measures. It only works on static table fields and calculated column.(measure not support aggregate)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.