Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 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?

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Employee
Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Kumail
Post Prodigy
Post Prodigy

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.