Bar chart years not in sequence

I am not sure how to fix my years to be in sequence. Like 2021 the 2022 then 2023. Currently I am using a bar chart and data for 2023 is before 2021. Any help is appreciated

Best Answers

  • ColemenWilson
    edited October 2023 Answer ✓

    Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.


    If I solved your problem, please select "yes" above

  • pauljames
    pauljames Contributor
    Answer ✓

    @Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Answers

  • ColemenWilson
    edited October 2023 Answer ✓

    Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.


    If I solved your problem, please select "yes" above

  • pauljames
    pauljames Contributor
    Answer ✓

    @Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!