Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning everyone,
something that will probably be simple for many, but for me it is not.
I need to rearrange the order of the hourly columns of the graph according to a personal order, that is, given the 24 hours, I need to have an hourly graph that starts from 6pm and ends at 8am
I actually managed to reorder it via custom reorder columns, but then I don't have a correct reference in the X axis
This is a chart I created with python, again through power bi and it is as I would like it but using the standard power bi charts
This is how the Power BI chart appears to me, where I created a column that I used to reorder the columns, but I don't have a correct header on the X axis
How can I solve it?
I’d like to acknowledge the valuable input provided by the @Greg_Deckler . His initial idea was instrumental in guiding my approach. Here is the specific testing I did about "Sort By column" for your referrence:
My sample:
1. Create a order table as follow
2. Merge two tables
3. Expand the table
Close & Apply
4. Select the Time column and Sort By column
Output:
If this sample data is structurally different from the one you are using, please do not hesitate to mention it and I will modify it.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@antonaccidavide Use a Sort By column on your original column of your correctly ordered column. Or you could just change the x-axis label
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |