Conditional Formatting not working with table columns.

[filipbobczuk]

Hello Everyone,
I have a column within a table that I want to display in a table visual. I wanted to add a background color to this column to it but when I go to Format -> Cell Elements -> select desired column and turn on Background color I cannot select it in the 'What Field should we base this on' (I can find it using the search but when I click on it nothing happens) and click ok which means no background color is applied. It is an INTIGER column.

[filipbobczuk]

Is there a way to make it work with the column without creating additional measure? I know it used to work like that.

[PijushRoy]

Hi @filipbobczuk 

Yes you can use Column also, find the below image

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks

[filipbobczuk]

Hey, 
thanks for the reply but as I stated in the initial post, I cannot select my column in the "What field should we base this on?" I click on it and this field stays empty and red as in the screenshot provided.

[PijushRoy]

HI @filipbobczuk 

Can you please share sample data or link for PBIX file and which column/field you are using for conditional formatting

[filipbobczuk]

Hey,
I am trying to make it work for a 'Days Since Stage Update' column which is an INTIGER.

[PijushRoy]

Hi @filipbobczuk 

Create measure at aggregate level can help

[PijushRoy]

Hi @filipbobczuk 

Please check the below articles, point no 4 and 5.
https://blog.coupler.io/power-bi-conditional-formatting/#:~:text=Select%20the%20field%20to%20apply,b....

Create a measure and use the measure in Field Value

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks