I have 10 measures in a Stacked Area chart, in two sets of 5. One set is anything less than and equal to today and the other set is anything forcasted or greater than today. My issue is that the two measures create a gap in the visual between today and tomorrow. Is there a way to close this gap? If I make both measures where today is in the data then they stack up and it looks worse...
Can you post some sample data and your DAX forumlas? My first thought is to alter the "Past Values DAX" to somehow also include +1 Day in the future Data. So if you were looking at Past data for 8/10-14, change the code so it 'fakes' a 15th date = 8/15 from your future data? (Or Duplicates 8/14 data for 8/15 in the Past if you can't pull from the future data?)
Did I answer your question, or help you along the way? Please give Kudos or Mark as a Solution!
Proud to be a Super User helping give back to the community! Thank You!
They are literally the same data, just want the line to change to dotted after Today(), if I make both sets where they have Today() in their data then it stacks all the lines together on one day and looks way worse than the gap. See this example where I had one of the forecasted measures be >= Today() instead of just >