Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bar chart sort

So I have a bar chart which is based on financed amount over the years in the dataset which is about 2 years however, it is combining the values for the same months but different years.   For examp...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add both your year and month columns to the x axis to create, but it may be better just to create a YearMonth column and use that alone.  Note that you may need to add a Sort By column to get the months to show in chronological order.  Or you can use a Date table like this one, where no sort by column is needed - No Sort Date Tables! – Hoosier BI

     

    YearMonth = FORMAT([Date], "YYYYMMM")  //for example

     

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can add both your year and month columns to the x axis to create, but it may be better just to create a YearMonth column and use that alone.  Note that you may need to add a Sort By column to get the months to show in chronological order.  Or you can use a Date table like this one, where no sort by column is needed - No Sort Date Tables! – Hoosier BI

 

YearMonth = FORMAT([Date], "YYYYMMM")  //for example

 

Pat