Forum Discussion
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...
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
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