Forum Discussion

ryanBI's avatar
ryanBI
Frequent Visitor
3 years ago

Graph is showing values but data is blank

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?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      ryanBI
      Frequent Visitor
      3 years ago

      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 IndexYearMonthValueRunning Total 23.24Running Total 22.23
      22022/23October0.00%0.00%0.00%
      22023/24October0.00%0.00%0.00%
      32023/24November0.00%0.00%3.47%
      32022/23November3.47%0.00%3.47%
      42023/24December2.31%2.31%12.14%
      42022/23December8.67%2.31%12.14%
      52022/23January19.65%6.36%31.79%
      52023/24January4.05%6.36%31.79%
      62022/23February23.12%13.30%54.91%
      62023/24February6.94%13.30%54.91%
      72022/23March9.25%26.59%64.16%
      72023/24March13.29%26.59%64.16%
      82023/24April8.67%35.26%77.45%
      82022/23April13.29%35.26%77.45%
      92022/23May6.94%35.26%84.39%
      92023/24May  84.39%
      102022/23June6.94%35.26%91.33%
      102023/24June  91.33%
      112022/23July5.78%35.26%97.11%
      112023/24July  97.11%
      122022/23August2.89%35.26%100.00%
      122023/24August  100.00%
      132023/24September  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