Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I'm trying to do a graph were I see the monthly sales gruped by day of the week - but for no reason the values are randomly sorted.
I can sort them in aphabetic order...but in this case I would need to set a custom order otherwise I get all the days in random order and my graph doesn't make sense (see below)
Is there a fuction that allows me to do that?
Thanks,
Eddie
Solved! Go to Solution.
Hi @eduzzino5,
You can still use the names of the days in the visuals. But the order will make sense because it's ordered by the numbers.
Best Regards!
Dale
Hi @eduzzino5,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @eduzzino5,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
You can create a column for this, I would use WEEKDAY:
https://msdn.microsoft.com/en-us/library/ee634550.aspx
Then you could set your "Sort By" for your "Day of the week" to be this new column.
Thanks a million for the reply 🙂
I thought about that, but I want to show my customers the name of the days, not the numbers...
Hi @eduzzino5,
You can still use the names of the days in the visuals. But the order will make sense because it's ordered by the numbers.
Best Regards!
Dale
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |