Missing date hierarchy

[Anonymous]

Hi all,

i read through some threats but none seems to do the trick for me. 

I have following situation....

top needs to look like the bottom

The setup seems similar. I added a calender table and linked accounting date with a one to many relation but still i am not showing a hierarchy.

I need it so that i can use it for sameperiod daxes.

Help is much appreciated

thanks in advance

BR,

Paul

[amitchandak]

Refer, if this can help

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Not-Available/td-p/490683

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460

[FrankAT]

Hi @Anonymous;

open File > Options > Options and settings:

Regards FrankAT

[v-kelly-msft]

Hi @FrankAT ，

Have you done the following setting:

open File > Options > Options and settings>Global:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Mariusz · Accepted solution]

Hi @Anonymous 

Have you marked your date table as a date table?

https://docs.microsoft.com/en-us/power-bi/desktop-date-tables

The Idea of using date table is that you use the columns in the date table rater then hierarchies, try the below.

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn