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 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!

 

 

Need Help
Show and Tell

6 Replies

  • 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).