Forum Discussion

dirkkoch's avatar
dirkkoch
Icon for Helper III rankHelper III
3 years ago
Solved

Date Hierarchy - Hide dates with no values

Hi, 

I am using a date hierarchy as x-axis within a stacked column chart. I want to keep this in order to be able to drillup and -down.

Nonetheless I do no want to see the dates where no values (for y-axis) are available. I need a dynamic solution for this since the days are not the same each month. So far I have not found a solution to this issue. Even if I filter another column (show no blanks) it still keeps displaying all calender days (with or without values).

 

I would be thankful for any suggestions / support!

 

  • Hi,

     

    Try to Change the settings on the X-Axis to Categorical:

     

     

2 Replies

  • Hi,

     

    Try to Change the settings on the X-Axis to Categorical:

     

     

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User

    dirkkoch ,

    Can you check whether "Show items with no data" option is diasbled by right clicking the X-axis date?

    Thanks,