Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So I have a line chart and bar chart combo, The bars are the industry average, then the blue line is my companies performance and the dotted line is a metric we want to beat. Now the dotted line is a 7 day moving average. I am wishing to take the last value from 3/6/18 and use that value for the rest of the dates. To make a straight line all the way across. What would i insert into my measure to make this so, below is my current measure
SS = DIVIDE(CALCULATE(SUM(OAG[Total Seats]),OAG[oper_carr]="__"),(CALCULATE(SUM(OAG[Total Seats]),ALL(OAG[oper_carr]))))
SS MA = CALCULATE([SS], DATESINPERIOD('Date'[Date], LASTDATE('Date'[Date]),-7, DAY ) )
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE([ss],DATESBETWEEN('Date'[Date],MAXX(ALL('Date'[Date]),'Date'[Date]),MAXX(ALL('Date'[Date]),'Date'[Date])))
If this does not work, share the link from where i can download your PBI file.
Hi,
I am unclear. Do you want to insert a 4th line (which will be parallel to the X axis) with a value which equates to the value on the last date?
Please clarify.
I want to make the black dashed line run parallel to the x axis. whit the value equating to the last value, which in this case is 3/6/2018 value.
Hi,
Try this measure
=CALCULATE([ss],DATESBETWEEN('Date'[Date],MAXX(ALL('Date'[Date]),'Date'[Date]),MAXX(ALL('Date'[Date]),'Date'[Date])))
If this does not work, share the link from where i can download your PBI file.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |