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

[Anonymous]

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? 😞

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

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 

[Anonymous]

You can try click format. 

Then axis X.

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

[Anonymous]

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]

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?