cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Cumulative graph not starting from 0

Hi all,

I'm trying to create a cumulative graph that compares revenue at the same point of the year for each of our past financial years. On the X axis I have day of the year (which is actually day of the financial year e.g. 1st July = day 1). I've created the following measure with some help from online:

TotalYTD = CALCULATE(SUM(New_Merge[Actual_Rate]), FILTER(ALLSELECTED(New_Merge), AND(New_Merge[Sale Date] <= MAX(New_Merge[Sale Date]), YEAR(New_Merge[Sale Date]) = YEAR(MAX(New_Merge[Sale Date])))))

However I cant work out why the lines are still on top of eachother and not all starting from £0 as they should?

Any help would be very much appriciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

## Re: Cumulative graph not starting from 0

Use following measure according to your columns.

Cumulative From Start = CALCULATE(SUM(Orders[Total_Sale]), FILTER(ALL(Orders),Orders[Order_date ]
<=MAX(Orders[Order_date ] )),VALUES(Orders[YEAR]))

also you can use VALUES(Orders[MONTH]) instead of year if required.

3 REPLIES 3
Community Support Team

## Re: Cumulative graph not starting from 0

Generally, you may modify your measure using DAX below and check if it can meet your requirement.

```Result =
TOTALYTD ( SUM ( New_Merge[Actual_Rate] ), ALLSELECTED ( New_Merge ) )
```

Community Support Team _ Jimmy Tao

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

Anonymous
Not applicable

## Re: Cumulative graph not starting from 0

Use following measure according to your columns.

Cumulative From Start = CALCULATE(SUM(Orders[Total_Sale]), FILTER(ALL(Orders),Orders[Order_date ]
<=MAX(Orders[Order_date ] )),VALUES(Orders[YEAR]))

also you can use VALUES(Orders[MONTH]) instead of year if required.

Frequent Visitor

## Re: Cumulative graph not starting from 0

@Anonymous

Fantastic! This really helped me to work it out. Initially this didn't show what I wanted, however I have now changed the Order Date for 'Day of Year' in the measure and my X axis is now 'Month of Financial Year' which seems to have fixed it! Measure now reads:

CALCULATE(SUM(New_Merge[Actual_Rate]),FILTER(ALL(New_Merge),New_Merge[FY DayOfYear]<=MAX(New_Merge[FY DayOfYear])),VALUES(New_Merge[Year]))

And graph now looks like the attached Thank you for your help.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 266 members 2,858 guests
Recent signins: