Forum Discussion
Displaying values underneath each bar on the X-axis
- 8 years ago
Hi
I follow the steps as you said, however, I don't face the same problem as you did.
Here is my pbix.
Please click more times on the "Sort By TimeStamp".
Best Regards
Maggie
Hi
Thank you for sharing such detailed information with us, it also prompts me to do a test with my Version: 2.58.5103.501 64-bit (May 2018).
In this situation, time is sort from 23 to 0, and I see “sort Z to A by time”.
After clicking on “sort Z to A” above, time is sort from 0 to 23, and I see “sort A to Z by time”.
“I can only sort Z to A, but not A to Z. I do not see that down arrow icon right to Sort by time”
How about clicking on the “sort Z to A” of your second picture, it does not work to show correct order?
Best Regards
Maggie
Hi Maggie,
thanks for your reply. I am using the same build Version: 2.58.5103.501 64-bit (May 2018).
Since we are using the same version, it might be that Power BI handles my data set differently, as I had to do some fairly complex cleansing and manipulations on my dataset.
That being said, I created a simple table with a time stamp (TimeStamp column) 0 to 23 and some arbitrary values (Volume column) for each hour.
Next, I loaded that table into Power BI, and I ran into exactly the same issues as described in my initial post.
I created a ribbon chart, then I dragged and dropped my TimeStamp on the Axis and Volume on the Value field.
Hours increment by 5 (0, 5, 10, 15, 20) and I can't change the increment to 1. So, I changed Type from Continuos to Categorical which displayed my chart exactly as shown in your first screenshot. But then, again, I was only able to sort Z to A. No other option available.
Since we are using the same build and you are able to sort bi-directionally and I can't - maybe I am missing something here. Can you take a look at the walkthrough above if I am maybe making a mistake I am not aware of which disables bi-directional sorting? Thanks.
Best,
Raf
- v-juanli-msft8 years ago
Community Support
Hi
I follow the steps as you said, however, I don't face the same problem as you did.
Here is my pbix.
Please click more times on the "Sort By TimeStamp".
Best Regards
Maggie