Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |