Cumulative sum and instant value at the same chart

[Anonymous]

I'm trying to create a chart just like the chart below, where I should have the total by day (columns) and the instant value of a variable along the day (line) at the same plot.

I'm able to create a cumulative bar just by setting the EndDate column at a bar chart to show the specific type of interval.

But I'm not able to set "Date Hierarchy" (for column chart) and "EndDate" (for line chart) formats for the same X axis (Or there is a way to do that?). I think that should solve my problem.

I tried to create a measure to sum values by day and then set that measure as my column chart, but didn't get the result I was expecting. What should I do?

Thank you!

[amitchandak]

@Anonymous , You should date the table with the required columns. and use that period from date table on axis .

Use measure like 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Hello @amitchandak. Thank you for yor reply.

I've tried that, but this is what I got.

Actually I want to get the total per day, instead of cumulative sum. 

The chart example I posted was created overlapping two charts. I'm trying to do the same using just one "line and stacked column" chart.