Forum Discussion
Helper IIShaping Dates into categories
Hi All,
I am trying to structure my X axis by hour but in a specific order. So by default Power BI would arrange my hours from 0 - 23
or it would kind of just mix them up as below.
The result i am trying to acheive is like this:
Please help me in the right direction to replicate the second visual
18 Replies
FreesemanI need the dates ordered from 18,19,20,21,22 then 23,0 Then 1,2,3,4 Then 5,6,7,8 Then 9,10,11 Then 12,13 Then 14,15,16,17
It is from 6pm to 5pm over a 24h
- Freeseman
Anybody have ideas:)
- v-easonf-msft
Community Support
Hi, Freeseman
You need to enter a custom table and then sort Column ‘Category’ by Column 'Sort column'.
After you establish a relationship between the custom table and the fact table, you can replace the existing fields with the new fields like below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Freeseman
v-easonf-msft Thank you for the advice. Please see https://community.powerbi.com/t5/Desktop/Average-per-Category-Please-help/m-p/2702026#M945089
I managed to get this far. Is the next step possible?
