Graph is showing values but data is blank

[ryanBI]

Hi,

Wondering if anyone can help me. I have a table of data, month on month, where I have a cumulative total as well. 

As you can see all months after April are blank and have no values, which is correct that's supposed to happen. However, the line graph I've tried to use displays the line as if there is data for these months.

The line continues after April when I need it to stop. It stops after August but needs that in April instead.

Any idea why this is happening and how to resolve it?

[v-yangliu-msft]

Hi  @ryanBI ,

After testing, in my case is displayed normally without for blank, did not reproduce your scene.

You can try to display the blank value as 0:

Measure =
IF(
    MAX('Table'[Value])=BLANK(),0,
SUMX(
    FILTER(
        ALL('Table'),
        'Table'[New]<=MAX('Table'[New])),[Value]))

This is my version of Power BI Desktop:

Is your Power BI Desktop the latest version, if not, you can update it in the following LINK:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=58494

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryanBI]

Thanks for your response! I think part of the issue is that I'm also trying to plot data from April onwards from a previous year. 

Sample data is below:

New Index	Year	Month	Value	Running Total 23.24	Running Total 22.23
2	2022/23	October	0.00%	0.00%	0.00%
2	2023/24	October	0.00%	0.00%	0.00%
3	2023/24	November	0.00%	0.00%	3.47%
3	2022/23	November	3.47%	0.00%	3.47%
4	2023/24	December	2.31%	2.31%	12.14%
4	2022/23	December	8.67%	2.31%	12.14%
5	2022/23	January	19.65%	6.36%	31.79%
5	2023/24	January	4.05%	6.36%	31.79%
6	2022/23	February	23.12%	13.30%	54.91%
6	2023/24	February	6.94%	13.30%	54.91%
7	2022/23	March	9.25%	26.59%	64.16%
7	2023/24	March	13.29%	26.59%	64.16%
8	2023/24	April	8.67%	35.26%	77.45%
8	2022/23	April	13.29%	35.26%	77.45%
9	2022/23	May	6.94%	35.26%	84.39%
9	2023/24	May			84.39%
10	2022/23	June	6.94%	35.26%	91.33%
10	2023/24	June			91.33%
11	2022/23	July	5.78%	35.26%	97.11%
11	2023/24	July			97.11%
12	2022/23	August	2.89%	35.26%	100.00%
12	2023/24	August			100.00%
13	2023/24	September			100.00%

Trying to plot the data like this:

But I want the orange line to stop at April rather than go flat the way it has. My PBI is up to date.

Thanks for your help