Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |