Solved: problem visualizing in a line chart - Page 2

Vetex_steven · ‎05-25-2020

I'm totally new to Power BI and I'm having problems visualizing my data in a line chart.

When I choose my columns, I have the impression that my date/time isn't showing correctly.

see also attachments

Can someone point me in the right direction?

v-jayw-msft · ‎05-27-2020

You can add the datetime column to AXIS field.

Then create a new table as slicer.

Table 2 = DISTINCT('Table'[datetime])

Since the min level of date range for the defult slicer is day, we need to create a measure as below and add it to visual level filter.

Measure = IF(SELECTEDVALUE('Table'[datetime])>=MIN('Table 2'[datetime])&&SELECTEDVALUE('Table'[datetime])<=MAX('Table 2'[datetime]),1,0)

You will need to select two value in the slicer (min time and max time).

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

problem visualizing in a line chart