Forum Discussion
Solved
Recreating following Excel visual on Power Bi?
So I have the following Visual in Excel that I want to create on Power Bi.
Cumulative Created (Yellow Line Value): start at 949 from 2021, then adds each month "Created" to the new sum(Running total). For example 949 + 49 = 998, etc.. On my Power Bi visual, this is the "Originated" bar
Cumulative Approved (Green Line Value): start at 852 from 2021, then add each month "Approved" to new sum. For example 852 + 9 = 861. On my Power Bi visual, this is the "Completed" bar.
Each line starts at the corresponding y-axis value.
How would I create these two measure, plot the line graphs in my Power Bi Visual, and create the same visual? I already have the Clusters bars at the bottom. I attached my Power Bi file with what I have so far.
Power Bi file:
5 Replies
You could make the chart with the Deneb visual, by layering 6 "mark"s (4 lines and 2 bars).
Pat
- You would need a Date table for cumulative aggregations. With a Date table, there are many YTD-relevant functions like TOTALYTD.If not, you at least need a MonthNumber column, so the comparison could be made to ensure all months smaller will be aggregated.The code is like thisCumulativeCreated =CALCULATE(SUM(Data[Created]),FILTER( ALL(Data[MonthNumber]), Data[MonthNumber]<=EARLIER(Data[MonthNumber])))
Hi,
There is a problem with downloading the file. The site is reported as unafe by MS Edge. Please share another download link. Also, how did you derive the numbers in the Backlog column?
Added a new link! Please take a look.
Also for Backlog column, I do not need
