Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart where months form the x-axis, and a percent of change from the previous month is being measured along the y-axis. At the moment, the x-axis values only show one month in the label (e.g Feb-17), but I'd like to customise it so it shows, for example, Jan-Feb-17. Obviously, is like this repeated for every month on there with the month before it.
Is this something thing that is possible?
Thanks
The simplest way is probably to load up this field as a dimension and use it?
So for example in your standard master calendar loader you can use something like
Month( addMonths(TempDate,-1))&'-'& Month(TempDate)&Year(TempDate) as MonthShift,
Please see the attached