Bar chart sort

[Anonymous]

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 example, if it is May 2021 and May 2022 its combining the values for both but i need them to be separated.

How do I do this?

[mahoneypat · Accepted solution]

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

[Kumail]

Hello @Anonymous 

If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.

You can send the sample .pbix file by adding it to your drive or dropbox and add the link here. 

Regards
Kumail Raza