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.
I want to show X-Axis with last 24 hours. If time now is 12 pm , then i have to show 12Pm now to 1 PM yesterday.
Problem here is when i am trying to sort in modeling, it throws error. because it has too many same values to sort.
Date Hour Min Avg Time
4/1/19 10:00 AM | 10 | 0 | 0.402727 |
4/1/19 9:59 AM | 9 | 59 | 0.080909 |
4/1/19 9:59 AM | 9 | 59 | 0.046 |
4/1/19 9:58 AM | 9 | 58 | 0.065384 |
4/1/19 9:59 AM | 9 | 58 | 0.07 |
4/1/19 9:58 AM | 9 | 58 | 0.186666 |
4/1/19 9:57 AM | 9 | 57 | 0.22 |
4/1/19 9:57 AM | 9 | 57 | 0.077857 |
4/1/19 9:57 AM | 9 | 57 | 0.197333 |
the graph is sorting like numbers from 0 to 23 or 23 to 0.
But i need like 17 18 19 20 21 23 0 1 2 3 4 5 6 7
Thanks
Solved! Go to Solution.
Hi @Anonymous
You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.
Regards,
Hi @Anonymous
You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.
Regards,
It will always sort from 13 - 12 like 13 14 15 16 17 ------- 10 11 12
But i need according to current time.
if time now 8m , Sort should be 8 7 6 5 4 3 2 1 0 23 22 21 20 --------- 12 11 10 9 .
@v-cherch-msft wrote:Hi @Anonymous
You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.
Regards,
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |