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 when I chart some call volumes and also sales volumes I want to chart them by day of week. Meaning on a column chart I want the axis to read left ot right as
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
However the chart sorts in either the following orders
Friday Monday Saturday Sunday Thursday Tuesday Wednesday
OR in the reverse order of the above. This unhelpful and useless as I cannot ever see anyone wanting these orders.
Someone please help.
I have see one solution whereby a use added the the labels a number (1.Mon 2.Tues 3.Wed etc) to force the order numerically but this looks unprofessional and will only deter people who are not advocates of Power BI.
Solved! Go to Solution.
First, the equation I gave uses the M language...in QUERY EDITOR. Your DAX solution will work, but a calculated column will almost always take up more space and reduce performance.
Second, sort your [Day] column by your newly created [Day of Week] column.
Highlight the [Day] column
Click Modeling -> Click Sort By Column -> click [Day of Week]
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |