Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So I created a bar chart which has one bar per month. I'd like to view this as 12 rolling months. When I choose relative date: 1 year it just adds the number from january this year to those of january last year. But what I want to see is bar number 1: january 2020, bar number 2 february 2020, ..., bar number 13 january 2021
Is this possible?
Thanks
Solved! Go to Solution.
@MarkRoosemont , I think you might have to display last 13 months.
Second, you have to use month yearmonth on axis
or Year and month both on axis with concatenated label off and sort on year month
Thanks, step 1 and 3 worked as a charm. But step 2 not so much until I saw the arrows in the upper right corner of the chart. After clicking on a couple of them, I suddenly got the view I was looking for! Thanks!
@MarkRoosemont , I think you might have to display last 13 months.
Second, you have to use month yearmonth on axis
or Year and month both on axis with concatenated label off and sort on year month
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |