Forum Discussion
Solved
Removing filter context from calendar hierarchy
Here's an example of the issue with some dummy data: I am adding annual projections to a number that is a sum from a different table. I have historical data that is aggregated monthly. I'v...
smanderson ALLEXCEPT('Calendar'[Year]) ?
Greg_Deckler
Community Champion
Community Championsmanderson ALLEXCEPT('Calendar'[Year]) ?
That was certainly better than anything I had tried so far.
It resullted in a stepped line. Is there a way to make it a gradual slope the same way it would look if the viz was aggregated by year instead of steps?
- Greg_Deckler
smanderson Hmm. Well, one way would be to add a trend line. The other way you could compute the y-intercept and slope of the line and then return points using that line equation.
