Combining year, month, day, & time into one dimension

[#1]

I have 4 separate fields that I want to combine into one field. Currently they are separated as year, month,
day, and time. The current goal is to use it as an x-axis for a line chart based on user selections for each field. I have done some research and haven't been able to find an answer for this solution. I've tried the concat function and couldn't get it to work.
What is the best way to do this?

Thanks,

Michael

[#2]

Hi,

you can try drill down

jus

[#3]

Hi,

Got your  expected result or still ?

Thanks & Regards'

Sarathi

[#4]

I used Dual(MakeDate(Year,Month,Day),Time) as a dimension expression and have it working operationally but it still does not show the time. Any tips off of what I've done already? We will try your method if this is not possible.

Thanks