Forum Discussion
admin11
Memorable Member
5 years agoHow to highlight GL Code =80018 back ground color ?
Hi All I cannot get it work , may i know where i go wrong ?
- 5 years ago
Hi admin11 ,
You can only use measure in this situation. In your sample, your GL Code is in text type because it contains both number value and string value. For text type column in rlues, it only have aggregation of count.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
admin11
Memorable Member
5 years agoThank you for sharing.
Now i want to use the build in feature , which is don't need to write expression. Which is using Format by Rule. Hope you can share with me how to make it work ?
https://www.dropbox.com/s/w5dgzalh3w7j58s/GL_WORKING%20v017%20ask.pbix?dl=0
Paul
amitchandak
Super User
5 years agoadmin11 , For some reason it is not showing MAX of GL Code, try to create a measure and use that with rule.