Forum Discussion

decarsul's avatar
decarsul
Icon for Helper V rankHelper V
2 years ago

Hide (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...
Need Help
Show and Tell
danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

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's avatar
decarsul
Icon for Helper V rankHelper V
2 years ago

exactly, it is weird. why would blank show as a value while its a nill?

Hope someone has a solution

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      decarsul
      Icon for Helper V rankHelper V
      2 years ago

      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's avatar
        danextian
        Icon for Super User rankSuper User
        2 years ago

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