Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Stefanve
Frequent Visitor

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?

 

Stefanve_0-1634897174304.png

Thanks,

Stefan

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
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.

 

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

View solution in original post

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @Stefanve ,

See the below ,the following result is what you want .

Base data:

vluwangmsft_0-1636014885958.png

Result:

vluwangmsft_1-1636014927539.png

 

create  a new hierarchy ,use date  and time.

vluwangmsft_2-1636014985370.png

Then create visual:

vluwangmsft_3-1636015047890.pngvluwangmsft_4-1636015119628.png

Final get:

vluwangmsft_1-1636014927539.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

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:

EXCEL_GnSADZjo0o.png

 

Thanks in advanced


Best regards

Josef

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
Super User
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.

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors