Forum Discussion
Continuous X axis using Date and Time dimension
BinaryBotany Can you confirm DateTime columns actual type in date time dimension is DateTime. I'm not sure why it would change to categorical. If you use the date time column directly on your visual, do you get continuous or categorical? I actually did a video on this link here, ofcourse it doesn't have a time element but it shows how you can year/month column as continuous.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
The datetime column in the datetimeDim is a datetime, and when used on the X asis along with the two fact measures, it works as expected (image 1 in the OP).
The issue comes when trying to recreate that same visual with separate date and time dimensions. Using date and time as a heirachy forces the X axis to a categorical axis (image 3 in OP, bottom visual). This is the challenge -- how to combine the date from dateDim and time from timeDim into a datetime that can be used on an X Axis to create a continuous axis.
Hi parry2k ,
Thank you for your video on this topic. Nicely explained.
