Forum Discussion
Conditional Formatting not working with table columns.
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.
7 Replies
- PijushRoyCommunity Champion
Hi Anonymous
Please check the below articles, point no 4 and 5.
https://blog.coupler.io/power-bi-conditional-formatting/#:~:text=Select%20the%20field%20to%20apply,based%20on%20the%20date%20values.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 - AnonymousNot applicable
Is there a way to make it work with the column without creating additional measure? I know it used to work like that.
- PijushRoyCommunity Champion
Hi Anonymous
Yes you can use Column also, find the below imageIf 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- AnonymousNot applicable
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.