Forum Discussion
Custom years comparison on one chart
Hello, I have a simple clustered column chart, which is showing month to month comparison between current year and last year. User can change the Year using slicer, and the report will show alwa...
hi Anonymous
For your case, you need to use DATEADD to custom them,
and this will lead to multiple measure, now you could combine them into one measure and use a slicer to switch them, see more details as below blog:
Regards,
Lin
hi Anonymous
For your case, you need to use DATEADD to custom them,
and this will lead to multiple measure, now you could combine them into one measure and use a slicer to switch them, see more details as below blog:
Regards,
Lin
v-lili6-msft, amitchandak isn't there a solution to make this more dynamic friendly and maintainable. What if a user wants to compare with 8 years ago? Each year comparison you need to put in the measure.