Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team, I am facing issue for ordering the months on x-axis of line chart. The month names are in Text data type. Below is the image of the data which i am getting result and the image in which format i needed.
Solved! Go to Solution.
OK,
Next step, order it by number of month, lets explain how:
In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.
tell me if works 🙂
try this:
In the top right corner, you should have a option for order, select month instead of sthe amount.
Yes i tried it. Since the months are in text datatype. So it is arranging in asseniding or decending orger of alphabets of Months.
OK,
Next step, order it by number of month, lets explain how:
In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.
tell me if works 🙂