Forum Discussion
Solved
Viewing months based on current date on charts
Hello, How can I change the order and view of months on the x-axis on a graph? I need to display financial YTD sales information. I have used the time intelligence functions to create a new ...
Here's how I would do it:
- Make a copy of your date column getting the start of the month: startofmonth = STARTOFMONTH(dates[yourdatecolumnhere])
- Change the format of that column to March 2001 in the Modeling tab.
- Add to your chart and make sure the X axis is listed as categorical.
You should end up with something like this:
- Make a copy of your date column getting the start of the month: startofmonth = STARTOFMONTH(dates[yourdatecolumnhere])
Ah, I see. It's because of your measure formula. Here's what I think are your options:
- You can remove your measure and replace it with the LineTotExcl field instead. That will include the missing months, but will make your chart start at January.
- I think in order to get the graph to start at April, you have to create a custom date/calendar table to create your fiscal year. I'm not familiar with how to do that, but I've read about others having to do this before. I won't be able to help you on that part, unfortunately.
Ah, I see. It's because of your measure formula. Here's what I think are your options:
- You can remove your measure and replace it with the LineTotExcl field instead. That will include the missing months, but will make your chart start at January.
- I think in order to get the graph to start at April, you have to create a custom date/calendar table to create your fiscal year. I'm not familiar with how to do that, but I've read about others having to do this before. I won't be able to help you on that part, unfortunately.
Ah thank you for that clafication.
I've seen online about making custom calendars and It looked very tricky to understand, but I guess that will have to be that way! Time to do some scraping. Cheers