The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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 🙂
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |