Attached is an example workbook for what I think you were looking for. A couple of notes:
- I only used the Measures for 2016 for Revenue and Units since the data was the same for 2018. Instead, I used the Date field to separate 2016 from 2018.
- I placed a discrete year value of Date onto the Color marks card to create a line for each year.
- I placed a discrete month value of Date onto the Columns shelf to give a shared x-axis.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Modex Report (WM).twbx 28.1 KB
Wesley Magee Hi Wesley Thank you so very much, this is very helpful.
But is there a way I can add a Filter or Parameter to view this chart in different Intervals? Like to view it in 7-Day Interval, 30-Day Interval and 90-Day Interval?
Is that even possible? Even not with a Filter or Parameter, is there another way? If so can you please help me with that please.
Yes, there are a few ways you could do this. One would be to create bins for day counts. To do this you would create a calculation doing a DATEDIFF between the Date field and Today(). Then create bins with a parameter that uses 30, 60, or 90.
Or you could create a calc where you truncate your date using DATETRUNC and use a parameter to swap out day, month, or quarter. It would look like this:
DATETRUNC([Date Parameter], [Date Field))