Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Line Chart - How to show full year axis by month BUT stop plotting data past current month

Does anyone know or have a workaround that will show the months for a full year in a Line Chart, and at the same time have the data cut off at the current year month?


This is my data where the measure is counting all the rows in the table. I want to see all the months in the year


This is my data where the measure is counting all the rows in the table WITH modified measure to show ZERO for months with no data. I don't want the line to keep running past the current month


Why can't I get it to show the full year and only plot line up to the curren month??

Edit:

The 'Show zero for nulls' works for a Bar Chart, but why does it not work for the Line Chart? 😞

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    You can try click format. 

    Then axis X.

     

    And in End option you can open the calendar and click today date.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous  I can't see that setting on my graph 😞


      I think it's because I am using the "Month & Year" from my calendar table instead of the "Date" because I don't want to see data plotted against each individual day (needs to be grouped by month)

      Would there be any other options?

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It seems to be an issue that only affects the line chart, the method to show 0 instead of blank works or bar graphs. 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Ashish_Mathur  I'm sorry I can't do that due to the information in the file. 

      I basically have a calendar table connected to a fact table, and counting the rows from the fact table