Forum Discussion
Time and date on x axis chart
Hi,
In the scenario below i have a date, time and temperature column.
What we are trying to visualize in a chart is on the x axis the time and date like the Excel example below.
Who can help me visualise this?
Thanks,
Stefan
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
4 Replies
- goncalogeraldes
Super User
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 - v-luwang-msft
Community Support
Hi 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 RegardsLucien
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.
