Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Can anyone help me how to create a cummulative stacked line chart in Power bi?
basically, I just wanted to replicate the graph below.
And I want to do these in running monthly.
Next update should be from September last year upto September current month.
Please assist me.
Thanks.
Solved! Go to Solution.
Hi @ecmurillo ,
As darentengmfs's suggestion, there are details to add here. You may set the relative date for the date slicer, select last 1 years, which will filter data from the last 1 year until current month automatically, see: Creating a relative date slicer and filter in Power BI .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ecmurillo ,
As darentengmfs's suggestion, there are details to add here. You may set the relative date for the date slicer, select last 1 years, which will filter data from the last 1 year until current month automatically, see: Creating a relative date slicer and filter in Power BI .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Where should the accumulation start from? Is it July of every year?
It should start from September 2019 upto September 2020.
Then I have to update it next month which starts from
October 2019 - October 2019.
and so on
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
Please put a date filter in your chart like how I suggested. Use Relative Date and the filter should be in the last 1 year.
@ecmurillo , Typically do cumulative like this with a date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))
if you want it to reset every year
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"9/30")) // or 8/31
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"9/30"))
Hi @ecmurillo
Do they following steps:
If it's not giving you the sequence you need in the chart, do this
When this is done, click on the visual, put Date into "Filter on this Visual", change filter type to Relative Date, choose "in the last", put 1, and choose "year". Check "Include today". This will give you the 365 days you want.
I can't get the visual I needed.
So far this is what i've got.
I want it to start from September 2019 upto September 2020
User | Count |
---|---|
140 | |
113 | |
104 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |