cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niccolo_guazz
Regular Visitor

Plot dataset with x-axis dates

Dear all.

I am working with a dataset with which I am creating a dashboard. My dataset is very simple, a first column of [yyyy-mm-dd-hh-mm], and a second column with many values.

I read in many threads and forum about the difficulty to plot dates on x-axis (including hours and minuts).

As reference I am using this dashboard built in PowerBi https://www.terna.it/it/sistema-elettrico/transparency-report/total-load .(Public data of Italian electric energy generation)

This is exactly the outcome I would like to obtain, but by now I cannot display the hours and minuts. I used their data to reproduce the dashboard.

I tried to switch from a "dates" x-axis to a "text" x-axis, but the result is not the same, and furthermore the plot does not occupy the whole page but I have to move to the right.

niccolo_guazz_0-1670078623424.png

I really cannot understand how the linked dashboard was built.

Any idea?

Thanks.

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @niccolo_guazz ,

 

To get this visualization working properly you need to extract the time to another column making your table look like this:

MFelix_0-1670081862331.png

 

Then use the Time column on your axis and filter for the last relative day

MFelix_1-1670081896304.png

This should give expected result.

 

If you want to keep the datetime stamp when you donwload it you need to do a different option:

  • Duplicate the date column
  • Format with hours format hh:mm
  • Use this column on your axis
  • Filter for the relative date

Has you can see below both charts are the same:

MFelix_2-1670082056436.png

For the more than one day option they only used the date column with the format of date.

 

See attach PBIX file.

 

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

The last field of the values is the tooltip you can add more fields to the tooltip, in this case add the original date column.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
niccolo_guazz
Regular Visitor

 Thanks @MFelix .

Do you know how I could show wven the day in the black-box below (in addition to the hour)?

And in general do you know how to modify the aspect of the box?

thank you.

niccolo_guazz_0-1670085972539.png

 

The last field of the values is the tooltip you can add more fields to the tooltip, in this case add the original date column.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix
Super User
Super User

Hi @niccolo_guazz ,

 

To get this visualization working properly you need to extract the time to another column making your table look like this:

MFelix_0-1670081862331.png

 

Then use the Time column on your axis and filter for the last relative day

MFelix_1-1670081896304.png

This should give expected result.

 

If you want to keep the datetime stamp when you donwload it you need to do a different option:

  • Duplicate the date column
  • Format with hours format hh:mm
  • Use this column on your axis
  • Filter for the relative date

Has you can see below both charts are the same:

MFelix_2-1670082056436.png

For the more than one day option they only used the date column with the format of date.

 

See attach PBIX file.

 

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.