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 want to remove the year from my line chart and only include the month. I have a custom sort on the month because I want it to show July 1 through June 30. If I try the date hierarchy to only show month, I can't get it to do a custom sort. I have also tried creating a new column with the format mmm and placing that into the line chart and it still doesn't work. It still shows the year. Help please!
Solved! Go to Solution.
@dwel0120 , You can have column like
Month = FORMAT([Date],"mmm")
Month sort = if(month([Date])>6, month([Date]) -6 , month([Date]) +6)
Sort month on Month Sort column.
But that will not work across year.
For that have two column on axis Year and month , Sort on them uncheck concatenate label, if need sort again
Hi @dwel0120 ,
You could try the below solutions:
Solution1:
Based on table ,create a new column:
month = FORMAT('table'[Date],"MMMM")
yearmon = FORMAT('table'[Date],"YYYYMM")
Then click month then sort by the new column:
Final create visual ,you will get you want:
Solution 2:
month = FORMAT('table'[Date],"MMMM")
Create a sort table :
then sort by index:
Create relationship:
Based on two table ,create visual :
Wish it is helpful for you!
Best Regards
Lucien
@dwel0120 , You can have column like
Month = FORMAT([Date],"mmm")
Month sort = if(month([Date])>6, month([Date]) -6 , month([Date]) +6)
Sort month on Month Sort column.
But that will not work across year.
For that have two column on axis Year and month , Sort on them uncheck concatenate label, if need sort again
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |