cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Cumulative line chart in combo chart

Hi there

I currently have a combo chart that looks like this:

The chart is based on a measure "Hours Saved" and shows values for each transaction date.

I would like to additionally have a line chart added that shows the cummulative value of hours saved up to that date.

Something like this:

Anyone know how this can be done?

Keep in mind that i do not have the values for hours saved each day in a table but it is made using a measure.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I

5 REPLIES 5
Highlighted
Super User IX

## Re: Cumulative line chart in combo chart

Create a cumulative measure like this

Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=maxx(date,date[date])))
Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=max(Table[Date])))

And use in combo chart like line and bar or line and clustered

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I

## Re: Cumulative line chart in combo chart

Using your solution seems to just give the same result without accumulation.

My "Hours Saved" measure as calculated like this:
Hours Saved = SUMX(QueueDB; RELATED(queuesROI[timeValueMin]))/60

I tried to calculate it this way:
Cumm = CALCULATE([Hours Saved];FILTER(QueueDB;QueueDB[transactionEND] <=MAX(QueueDB[transactionEND])))
Highlighted
Community Support

## Re: Cumulative line chart in combo chart

Hi @TKLAAB ,

Refer the formula below and see if it helps.

``````Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date]))

Measure 2 = CALCULATE([Measure],FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))``````

Here's the result about my sample data.

If this not help, please share some sample data if you don't have any Confidential Information.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Helper I

## Re: Cumulative line chart in combo chart

How do I upload a data sample here for you to see?

Highlighted
Helper I

## Re: Cumulative line chart in combo chart

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors