Forum Discussion
Traffic Lights
Hi All,
I created a table to show a pipeline health. Basically, I wanted to show the health if the pipeline is above their 5x ('24 commit times 5).
I created a measure:
I am not sure If I am doing it correctly.
Hoping for your assistance.
Thank you,
Lorenz0210
lorenz0210 , Field value should return color. if you want to use conditional formatting
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
BD Pipe Health = IF([BD Qualified Pipe]<=[BD Pipe 5X],"Red","Green")
UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50
4 Replies
lorenz0210 , Field value should return color. if you want to use conditional formatting
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
BD Pipe Health = IF([BD Qualified Pipe]<=[BD Pipe 5X],"Red","Green")
UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50Appreciate the help. It works!
Hi lorenz0210
Instead of "field value" in the conditional formatting window you should use "rules"If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
I forgot to ask, at the Total of the table the UNICHAR stays black circle, is there a way we can show it as blank or the overall color if it is a green or red?
