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.
Hi all, i have a table is use in a chart as the below
when i put this data in chart it starts with April ( sorting alphapticaly ) but i want the data to start with july - august as the table
Solved! Go to Solution.
Hi,
Try to create a column for Month like:
Month ID = Switch(Table[Month], "July", 1,"August", 2, "September ", 3,.....)
Likewise, complete all 12 month. Then go to Data Tab (just above relationship tab at left most pane) then Select your Month Column then you will see "Sort by Column " option on the top menu where you need to select the Month ID (Above calculated column).
So automatically your chart will get sorted as per your Month ID.
Hi @MostafaGamal ,
You try to add a Conditional Column in Power Query Editor as follows. Then select Month column to sort by this new column.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MostafaGamal ,
You try to add a Conditional Column in Power Query Editor as follows. Then select Month column to sort by this new column.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Try to create a column for Month like:
Month ID = Switch(Table[Month], "July", 1,"August", 2, "September ", 3,.....)
Likewise, complete all 12 month. Then go to Data Tab (just above relationship tab at left most pane) then Select your Month Column then you will see "Sort by Column " option on the top menu where you need to select the Month ID (Above calculated column).
So automatically your chart will get sorted as per your Month ID.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |