Forum Discussion
Solved
Scatter graph
Hi all, I have a scatter graph showing the number of items per month going through governance. This works fine. What I am trying to do is add an additional line which is the total, like a waterf...
If you use a Line and Stacked column Chart with a measure like this:
The DAX removes any items that happen on or before this month i.e keep future items only:
Total remaining =CALCULATE([Your Measure] --Measure to change filters,ALLSELECTED(TableToUnfilter) --Remove all filters on table w/ date,Table[DateColumn] > MAX(Table[DateColumn]) --All sales after current, Year(Table[DateColumn]) = YEAR(Max(Table[DateColumn]])--Same year))+0 --Add 0 to keep line continuous, set line to stepped or smoothWe have a free video series on DAX that might help!
something like this ideally
If you use a Line and Stacked column Chart with a measure like this:
The DAX removes any items that happen on or before this month i.e keep future items only:
Total remaining =
CALCULATE(
[Your Measure] --Measure to change filters
,ALLSELECTED(TableToUnfilter) --Remove all filters on table w/ date
,Table[DateColumn] > MAX(Table[DateColumn]) --All sales after current
, Year(Table[DateColumn]) = YEAR(Max(Table[DateColumn]])--Same year
))+0 --Add 0 to keep line continuous, set line to stepped or smooth
We have a free video series on DAX that might help!