Forum Discussion

lord_kaiser's avatar
lord_kaiser
Helper I
8 years ago
Solved

Column 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 mon...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
lord_kaiser
Helper I
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    lord_kaiser
    Helper I
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      lord_kaiser,

      Please share your pbix file via Private Message.

      Regards,
      Lydia

      • lord_kaiser's avatar
        lord_kaiser
        Helper I
        8 years ago

        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