Forum Discussion
Dates
Anonymous , When you create a date table and mark it date column it will ask for date that will become Key. So you will not have a hierarchy.
You can create a custom hierarchy or have another date column that can have hierarchy
Date 1 = [Date]
Hi Anonymous
you have to keep two differences in mind:
-
The first icon is used for a table that is set as calendar table. In the calendar table, you can create any own hierarchies. In model view, simply drag the month column over the year column, and so on.
-
The second icon marks a column that contains dates and is internally managed by Power BI Desktop and provided with a date hierarchy. This operation can be influenced in the options settings. You have no influence on these hierarchies!
Take a look at tab File > Option and settings > Option > Load Data (Global) > Time intelligence > Auto date/time for new file.
Take a look at tab File > Option and settings > Option > Load Data (Current File) > Time intelligence > Auto date/time.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)-
Hi Anonymous
you have to keep two differences in mind:
-
The first icon is used for a table that is set as calendar table. In the calendar table, you can create any own hierarchies. In model view, simply drag the month column over the year column, and so on.
-
The second icon marks a column that contains dates and is internally managed by Power BI Desktop and provided with a date hierarchy. This operation can be influenced in the options settings. You have no influence on these hierarchies!
Take a look at tab File > Option and settings > Option > Load Data (Global) > Time intelligence > Auto date/time for new file.
Take a look at tab File > Option and settings > Option > Load Data (Current File) > Time intelligence > Auto date/time.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi FrankAT
Thanks for your reply. I suspect I did not make myself clear in my original question.
I have resolved the heirachy issue, so thank you for your's and amitchandak assistance.
Kind Regards
Anonymous , In case non of the above solutions, worked. Post your solution and mark that as the solution. So others can get benefited. If something above worked, mark that as a solution.