Forum Discussion
Date hierarchy
Hello, I have a question about the date format of my table. I don't know why I can't get a Date hierarchy. I would like to get a Date hierarchy or only extract date with year 2021.
Hi Anonymous ,
Firstly, you don’t have to create hierarchy. You can achieve identical functionality by adding multiple columns(Year, Month) to the "Axis" of a bar or column chart. This way, the chart will also enable you to dill down the data.
Secondly, you are able to create Date table using M query or DAX expressions in Power BI Desktop. For more detailed steps, please review the following blogs.
http://www.agilebi.com.au/power-bi-date-dimension/
http://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-steps...
Best Regards
Community Support Team _ polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.