Time and date on x axis chart

[Stefanve]

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

[v-luwang-msft]

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 Regards

Lucien

[jmeile]

Hi @v-luwang-msft 

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 regards

Josef

[huntersull]

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.

[goncalogeraldes · Accepted solution]

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.

https://whitepages.unlimitedviz.com/2020/05/formatting-the-x-axis-in-power-bi-charts-for-date-and-ti...

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