Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello I am trying to build a line graph with dates from 2 different columns, I have attached a sample file.
I am looking to have WeekNum on the bottom of the graph and the values would be the cumulative number of items for the week num.
Line one would be Forecast/ Line 2 would be Actual
I can calulate the cumlative totals but I am stuck on getting a week number, that works for both cumalitve total measures
my original attempt was create an Actual weeknum column and a Forecast weeknum column, then I can create the cumulative total measures but that leaves 2 graphs / with one axis usint the actual weeknum column and the other using the forcast weeknum column
@Anonymous
Something like this?
not quite, it would be cumulative so each line would only go up, never down
so this? Adjusted the measure to have cumulative values - somehow missed that in the original reply 🙂
yep! how did you do that
Reformatted your data
Used 3 measures
Did I answer your question? Mark my post as a solution 🙂
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |