Forum Discussion
Conditional formatting of icons using field value
Hi,
I am able to conditional formatting of font color using filed value OEE2 machine color, but the same filed value is not working for icons. Should i use different thing instead of hex codes to display tick mark and cross mark. please suggest.
OEE2 Machine color = SWITCH(true(),[OEE2%]>[OEE2 machine target],"#008000",[OEE2%]<[OEE2 machine target],"#FF0000")
I am able to do using rules and the icons are dispalying as shown below, but i don't want to hardcode the value like 68% instead i want to chose from a measure just like OEE2 machine color.
Hi aneesh2020,
You can do it this way:
Create an additional measure that will have your condition, which icon should appear and assign values 0 and 1 there.
Then, on the basis of this new measure, do conditional formatting and set Rules instead of larger, smaller - "is" and select the icon.Thanks to this, 0 and 1 will change dynamically, and thus the icons will also change.
_______________
If I helped, please accept the solution and give kudos! 😀
3 Replies
- lkalawski
Resident Rockstar
Hi aneesh2020,
You can do it this way:
Create an additional measure that will have your condition, which icon should appear and assign values 0 and 1 there.
Then, on the basis of this new measure, do conditional formatting and set Rules instead of larger, smaller - "is" and select the icon.Thanks to this, 0 and 1 will change dynamically, and thus the icons will also change.
_______________
If I helped, please accept the solution and give kudos! 😀 - Greg_Deckler
Community Champion
Trying to remember, you need to have a numeric based-on field that is why it is not working with your hex codes.
