I want to create a chart with two levels, discrete(Month) above discrete(Year) on the X-axis. The closest I can get is Month at the bottom of the graph and Year at the top of graph.
The first attachment is the Month at the bottom of the graph and Year at the top of graph. The second attachment is how I want the X-axis formatted. Please help!
Jan 5, 2018 8:16 AM
Hi Ryan
Not exactly what you want but see below
I changed the date to MY and then added an Index() to the column shelf - then made it discrete and placed it before the date dimension - that forced the date to the bottom
I then un-selected show header on the index
Maybe someone else knows another way
Jim
If this posts 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.
Hi Jim, not exactly what I want. My goal is to eliminate the repetition of the year 2017 to eliminate clutter but position the year below the month so the audience does not have to jump from the top of the graph to the bottom.
Jan 5, 2018 9:00 AM
Figured as much
Good luck
Maybe someone else can help you out
Ryan,
This may not quite be there, but the Automatic Subtitle might help (with the top year header hidden
and a [space] for the Title):
Thanks swaroop.gantela, its a good work around.
I can't figure out how to delete the brackets from the Year. Also, because Month is continuous, the Month axis labels are offset from the bar which looks unusual.
Ryan,
I don't think there is a way to remove the brackets.
With respect to the month labels, I think the best that can be done is to rotate the labels as
shown below. Any other adjustment to the Date format will remove the Subtitle.
