Forum Discussion

LindaHa's avatar
LindaHa
Helper I
9 years ago

Define a start value (date)

Hello,   my x-axis uses dates (e.g. 01.01.2016). Unfortunately I cannot compare the different graphs as they display only the dates with values. I only want the x-axis to start at 01.12.2015. What ...
Need Help
LindaHa's avatar
LindaHa
Helper I
9 years ago

Hi ankitpatira,

 

unfortunately the first solution does not work as I have a filter applied and the filter is the reason why the values in December are empty. Although they are empty I would need the empty x-axis value to be shown in the graph. When I go to the paintbrush icon and try to add a start value for the x-axis the field turns red. I think it wants to show me that the format I entered is wrong.

 

Thanks in advance Linda

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi LindaHa,

Could you please post sample data of your scenario and describe more details about  what filter you are using? I make a test using the following sample data, when I click “Show items with no data” for x-axis field, the visual shows expected result.





However, if you use visual level filter to set y-axis value to be not blank, the visual cannot show Aug 2016 label in x-axis.



In addtion, we are not able to enter date in Start on x-axis.

Thanks,
Lydia Zhang

  • LindaHa's avatar
    LindaHa
    Helper I
    9 years ago

    Hi Lydia,

     

    thanks for your reply.  I have activated "show items with no data" and "month" on my x-axis. I have activated a page level filter and some visual filters.

     

    This is my set up:

    • LindaHa's avatar
      LindaHa
      Helper I
      9 years ago

      Sorry I forgot to post my filters:

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi LindaHa,

        As we are not add date in Start on x-axis, in your scenario, you would need to remove the month-year filter in order to show label of 2015.

        Thanks,
        Lydia Zhang