Column Chart Help

[lord_kaiser]

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

[v-yuezhe-msft · Accepted solution]

@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

[v-yuezhe-msft · Accepted solution]

@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_kaiser]

Thanks 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

[v-yuezhe-msft · Accepted solution]

@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

[lord_kaiser]

Hi Lydia,

Thanks for your help thus far.

I tried to replicate the steps and I'm still not having any luck.

Still not able to sort in mobth-yr order

[v-yuezhe-msft]

@lord_kaiser,

Please share your pbix file via Private Message.

Regards,
Lydia

[lord_kaiser]

Hi Lydia,

Apologies for getting back to you late as i was away.

After playing around with your suggestion earlier, i managed to get it to work.

Thanks