Forum Discussion

sheap069's avatar
sheap069
Icon for Helper III rankHelper III
5 years ago

Display All Intervals for x-Axis in Timeline

Hello,    I have a timeline in a bar and line chart as shown below.     I made a measure to get the weeks in the months, and I have these numbers displayed as you can see. However, why are...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sheap069 , Your axis type might be continuous . make it categorical and check

  • sheap069's avatar
    sheap069
    Icon for Helper III rankHelper III
    5 years ago

    Hi, I don't see this option under x-axis.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi sheap069 ,

      The Type option with value Continuous and Categorical only show up in Format pane when you put the field with numeric or date data type... How did you set your line and column chart? Which field be put on X axis? Could you please provide some sample data(exclude sensitive data) include in your visual? Thank you.

      Best Regards

      • sheap069's avatar
        sheap069
        Icon for Helper III rankHelper III
        5 years ago

        Anonymous Hello,

         

        Sorry for the delay, it took some time to make fake data for you. You can find it here. 

         

        You will see three tabs. I have Groups, Applications, and then I unpivoted the Applications table to have the dates. I want a count of applications for each group based on the type of Date. I have 2 different group IDs to show you what's wrong.

         

        I want the timeline to show the past 12 months, assuming the current time was February 2020. Group ID 1 has no data from 2019, and while the table is blank, there is oddly Jun 2019 showing up in the axis. 

         

        For Group ID 10, there are all the bars except March 2019. Why is there nothing in March?

        Also, I would like to have the axis always show all the months. Here is another Group ID, and you can see the months are not all showing.

        I really need to have all months displayed on the axis, whether or not there is data.

         

        I made a custom column for the months and made a sort order so the months show up correctly on the chart.

        Here are my fields for the chart. The line graph is for a separate value.

         

        Sorry if this is complex. Let me know if I can clarify anything, but I need to have Jan 2019 to Jan 2020 (later I can set 12 months from today) always appear on the graph and not have the x axis change dynamically.

        Thank you