Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table containing, Year, and WeekNumber in two columns the data, WeeklyPercentage, and a sorting column Sort.
I want to display the data on a graph with year and week number along x axis, WeeklyPercentage on the y axis and EscatlationLevel as the legend.
The graph always displays with the sorted by the WeeklyPercentage descending (sorted by y axis rather than x axis). I want to display with the x axis sorted
I have added the Sort column, but if I try and sort the WeeklyPercentage columns (contains duplicates) by this Sort column (doesn't contain duplicates) I get the following error.
How do I display with the X axis is sorted by Year and then WeekNo?
Solved! Go to Solution.
Hi @Anonymous
You may try to use 'Sort by' as below picture.
Regards,
Cherie
Hi @Anonymous
You may try to use 'Sort by' as below picture.
Regards,
Cherie
That seems to have sorted it. So Simple when you know how!
can you add some sample data. So, I can try.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |