Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data with Dates, amount value for every date. I tried line graph but it is showing year not able to show Month year on x axis. I tried new column "Month-Year" and set on x axis but line graph looks change it is not same look as done with Date. It consider sum for months and year. Please let me know how i can fix this
Hi @Anonymous
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!
Hi @Anonymous
Use below formula to convert the Date as a new calculated column:
Month = FORMAT('Date'[Date], "mmmm") & " " & YEAR('Date'[Date])
Then drag it to X-axis:
If you've created a manual mth-year column and your data on the graph looks strange, it's probably because the graph is sorted/ordered alphabetically. You will need to create a column that will show the order of the mth-year.
Mth Year Mth Year Index
Jan-19 1
Feb-19 2
Mar-19 3
Then in the Modelling section, select the column that you have Mth-Year in and then select the Sort by Column option and then select the Mth Year Index, this will order your Mth Year Index properly.
Proud to be a Super User!
thanks for the quick response. I will try that but i need to display "Month -year" in x axis instead of "year"
If you create a Mth-Year column in your data model and have a Mth-Year index then it'll work fine.
Let me know how you get on, happy to help.
Proud to be a Super User!
using date field in x axis my graph looks like but it should year. I need show in this format but in x axis display month and year
as suggested in this post, i tried doing new columns month-year and month year index , my graph looks like this which is incorrect
Hey, the graph is incorrect as you needed to order the Mth-Year otherwise it orders alphabetically, that's why you see Dec-2017 beside Dec-2018. I think I've misunderstood what you wanted originally, you still want the intervals to show individually and not rolling them up into a monthly view.
Proud to be a Super User!
I still want the intervals to show individually
You can get this by putting the year and month separately in the Axis, then using the expand down option. See the pics below...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |