Series Order

When I build grouped bar charts, I'm created a 2015 v 2016 series to split values. In some cards, 2015 comes before 2016 and in others, 2016 comes before 2015. How can I ensure they are consistently in the same order?

Best Answer

  • Godzilla
    Godzilla Contributor
    Answer ✓

    have you tried adding the field that contains the year values as a second sort? So if you look at the Sorting area in Edit mode, you should have two fields in the Sort area Month and Year. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Godzilla
    Godzilla Contributor

    are you sorting the charts using the field has the year values?

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • They are sorted by month and split into a grouped bar. One bar is for 2015 and the other is 2016.

     

    0489681aee20f03de3b68f82b1303d36.png

  • Godzilla
    Godzilla Contributor
    Answer ✓

    have you tried adding the field that contains the year values as a second sort? So if you look at the Sorting area in Edit mode, you should have two fields in the Sort area Month and Year. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.