Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Resulted data
Required Format Data
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 🙂
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |