Forum Discussion
Time and date on x axis chart
Hello there Stefanve ! You can implement a similar solution to the one proposed in the following link. THe only difference is that you will have to add the "Time" field to the date hierarchy.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Community SupportHi Stefanve ，
See the below ,the following result is what you want .
Base data:
Result:
create a new hierarchy ，use date and time.
Then create visual:
Final get:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I'm trying to do what you described here. I managed to create the pivot table and the hierarchy, but I don't know where to find the "Concatenate labels" option. How do you get there?
After I got the Pivot Table, I created a Pivot Chart, but I don't know what's next.
Here is how it looks like:
Thanks in advanced
Best regardsJosef
You're using Microsoft Excel, whereas the post you're replying to was using Microsoft PowerBI for Desktop.
You cannot follow his instructions in Excel.
