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.
We wish to create a visualization which distributes costs according to the month the costs were paid.
Thus, I have created a visualization where the x-axis is the date (created as a hierarchy) and the values are the amount of costs.
The problem is that, the visualization only distributes the costs on a timeline, when the year is the x-axis. When i enter a deeper level of the date hierarchy, the visualization will show the months as if the data is to be shown from january to december. However, if i filter data e.g. from August 2018 to February 2019, the visualization will still be from january to december. Instead of this, i would like the visualization to be as followed: August, September, October, November, December, January, February. How do i solve this?
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, it looks like such a requirement is not achievable. As a workaround, you could click the third "Drill Down" button to drill down to "Year-Quarter-Month" level.
Best regards,
Yuliana Gu
Hi @Anonymous,
Based on my test, it looks like such a requirement is not achievable. As a workaround, you could click the third "Drill Down" button to drill down to "Year-Quarter-Month" level.
Best regards,
Yuliana Gu
That seems to be the solution
Thank you for the advice
Best regards
Jonas
So, to get a custom sort order, you need to create a column that has a sort the way you want it and choose your original column and do a Sort By your other column. So, for example, if you have a column:
January
February
March
April
May
June
July
And you wanted a sort order like July - January you would create a column that was 7,6,5,4,3,2,1 for those months. You would set the Sort By of the original month column to your new numeric column.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |