Forum Discussion
decarsul
Helper V
Helper VHide (Blank) label but keep values
Hi there! when making a chart using a double X axis with labels and a date hierarchy, there are values that fall outside off the dates for whatever reason and as such, cannot be plotted to the ax...
danextian
Super User
Super UserHi decarsul ,
If you're referring to the x-axis label, there is a conditinoal formatting option but that doesn't seem to be working. I am expecting green for 202401 but they all return blue
decarsulexactly, it is weird. why would blank show as a value while its a nill?
Hope someone has a solution
- danextian
If the conditional formatting works fine, you should be able to render a text invisible by making it fully transparent using RGBA(0,0,0,0) in the conditional formatting measure (it will return 100% transparency as long as the 4th number is zero, the other zeroes can be anywhere from 0 to 255).
- decarsul
That is the thing tho. it doesnt.
I applied conditional formatting to blank, null or 0, and it doesn't apply conditional formatting to the label 'Blank'.