Forum Discussion
Continuous X axis using Date and Time dimension
BinaryBotany I see what is going on. when you are using Expand All down in the hierarchy, it concatenates the x-axis and that's what makes it a text column (internal behavior) you don't see continuous but when you use go to the next level in the hierarchy or turn on the drill on , it works fine. the following video explains the behavior. I hope it all makes sense.
✨ Follow us on LinkedIn and to our YouTube channel
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.
Good observation. When using "Go to next level in the heirachy", it effectely moves between having the date on the axis, and the time on the axis, both which, by themselves, uses a continuous axis. Unfortunately, I need datetime on the axis.
Drill down doesn't work either -- it still converts the X axis to categorical.
As you say, the internal process is to join the date and the time into a string rather than a datetime when "expanding all down". So how can we work around this limitation? Is there some way we can create a datetime from the data and time dimensions that can be used on an axis? (other than creating a whole new datetime dimension table)