Forum Discussion
Helper IColumn Chart Help
Hi There,
I currently have 2 years worth of data that i have on a stacked column chart visual.
The issue i have is that when i try to represent the column chart by months, it groups the 2 months together.
i.e-If my data contains Jan-15,feb-15....Dec-17
Jan-16 & Jan-17 are grouped together as January on the column chart.
How can i change this to represent every month on the chart-Jan-16,Feb-16.....Dec-17
Thanks in advance
lord_kaiser,
Do you have a date type field in your table and drag the field to X-AXIS of the column chart? If so, display the date field as Date Hierarchy in the column chart, then click the third button to expand the column chart. For more details, please review the following screenshots.
Regards,
Lydialord_kaiser,
You can create YearMonth calculated column in your table and drag it to X-axis of the chart.
Year= Year(Table[Date])
MonthName= SWITCH(MONTH(Table[Date]),1,"Jan",2,"Feb",3,"Mar",4,"Apr",5,"May",6,"Jun",7,"Jul",8,"Aug",9,"Sep",10,"Oct",11,"Nov",12,"Dec")
YearMonth = Table[MonthName] &"-" &Table[Year]
Regards,
Lydia
6 Replies
lord_kaiser,
Do you have a date type field in your table and drag the field to X-AXIS of the column chart? If so, display the date field as Date Hierarchy in the column chart, then click the third button to expand the column chart. For more details, please review the following screenshots.
Regards,
Lydia
lord_kaiserThanks for this Lydia.
Just another question whilst we are on the same topic, if i wanted to abbreviate the month and year to just Aug-15 and in order by month & year, how woul di go about doing this?
When i attempt to do this,, it gives me Aug-15,Aug-16,Aug-17 as opposed Aug-15,Sep-15,Oct-15
I have a suspicion that this may be because it has converted it to text?
Thanks
lord_kaiser,
You can create YearMonth calculated column in your table and drag it to X-axis of the chart.
Year= Year(Table[Date])
MonthName= SWITCH(MONTH(Table[Date]),1,"Jan",2,"Feb",3,"Mar",4,"Apr",5,"May",6,"Jun",7,"Jul",8,"Aug",9,"Sep",10,"Oct",11,"Nov",12,"Dec")
YearMonth = Table[MonthName] &"-" &Table[Year]
Regards,
Lydia