Forum Discussion

Shahzad's avatar
Shahzad
New Member
10 years ago

How to create Year, Month, Date hierarchy while creating reports in Power BI

Hi All,     I have created a report in power BI, this has seperate month and year fields in a period dimension. but i have difficulties in making a hierachy for it. eg: year 2016 month January or ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Shahzad,

What is the exact error message or problem you get when creating Date hierarchy?

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/


Thanks,
Lydia Zhang