Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |