Forum Discussion
Date Table
Hi, koorosh
'Mark as a date table' most of the time is to use the time intelligence functions. In fact, it is not suitable for newcomers if you need the date hierarchy. As you can see, you can’t use a default hierarchical structure to display data in visual.
If you want to create your own date table and define your own date hierarchy, you can mark as a date table.
Set and use date tables in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _ Janey
koorosh apart from Anonymous said, if you are using date column on the x-axis (in image 1) and the type of x-axis is set to continuous (on format pane), Power BI decided what value it will show on the x-axis, currently, it is showing year, if you filter on shorter date range, it might show month or date on the x-axis and you cannot control it. Again this is only applicable if you are using date type column on the x-axis and type is set to continuous.
✨ Follow us on LinkedIn
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.⚡