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

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