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.
Hello,
I have a Line Chart posted below. And the sort of the chart is not correct for some reason. In my Date slicer I have 1/1/2017 - 12-31/17 to get all of 2017. However in the Chart it is displaying in order of March, August, January, October, June, February ...... and so on. Perhaps it is because in the Date Slicer I am using a field called FullDate and in the chart Axis I am using a field called MonthName, maybe the different fields are causing this? Any ideas what I can try.... Thanks!
Solved! Go to Solution.
Hi.
I dont know what your calendar table looks like, but if you use a separate date dimension or calendar table try this:
To create a YearMonth-column if you dont have one you can add a custom calculated column in your date dimension table. A good format for such a column is "YYYYMM". This format will allways sort in the correct order. After adding this column you can choose it as a "Sort By Column" as per instructions above.
Hi.
I dont know what your calendar table looks like, but if you use a separate date dimension or calendar table try this:
To create a YearMonth-column if you dont have one you can add a custom calculated column in your date dimension table. A good format for such a column is "YYYYMM". This format will allways sort in the correct order. After adding this column you can choose it as a "Sort By Column" as per instructions above.
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |