Hide (Blank) label but keep values

[decarsul]

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 axis. This results into a (Blank) category.

Now i want to simply remove this label, but keep the values. 

I tried 'hiding' it with conditional formatting, but that doesn't work.

Any suggestions would be welcome!

[danextian]

Hi @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

[decarsul]

exactly, 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'.

[danextian]

The conditional formatting on X-axis label or any other axis labels doesnt work. I dont even know why it is there.

[decarsul]

so.... bug? 😄