https://community.fabric.microsoft.com/t5/Developer/Time-Hierarchy-not-showing-correctly/m-p/4002413#M53516 <P>Hi,</P><P>&nbsp;</P><P>So I have created a date table with Dataflow Gen 2, which is then upstreamed to Datawarehouse and then added to a senmatic model. I have define the table as Date Table and have created hierarchies but when this hierarchy is used in a visual in PowerBI, it's only showing number for months and quarters rather than Jan, Feb, Q1, Q2 etc.&nbsp;</P><P>&nbsp;</P><P>I have ensured Time Intelligence are turned on in the global settings and but could not do so for current file due to the nature of the data source.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ferr_0-1718897655285.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1119719i7988C2A564DC7A00/image-size/medium?v=v2&amp;px=400" role="button" title="Ferr_0-1718897655285.png" alt="Ferr_0-1718897655285.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ferr_1-1718897671533.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1119720iE56829A62CEDD358/image-size/medium?v=v2&amp;px=400" role="button" title="Ferr_1-1718897671533.png" alt="Ferr_1-1718897671533.png" /></span></P><P>&nbsp;</P> Thu, 20 Jun 2024 15:37:37 GMT Ferr 2024-06-20T15:37:37Z https://community.fabric.microsoft.com/t5/Developer/Time-Hierarchy-not-showing-correctly/m-p/4002413#M53516 <P>Hi,</P><P>&nbsp;</P><P>So I have created a date table with Dataflow Gen 2, which is then upstreamed to Datawarehouse and then added to a senmatic model. I have define the table as Date Table and have created hierarchies but when this hierarchy is used in a visual in PowerBI, it's only showing number for months and quarters rather than Jan, Feb, Q1, Q2 etc.&nbsp;</P><P>&nbsp;</P><P>I have ensured Time Intelligence are turned on in the global settings and but could not do so for current file due to the nature of the data source.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ferr_0-1718897655285.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1119719i7988C2A564DC7A00/image-size/medium?v=v2&amp;px=400" role="button" title="Ferr_0-1718897655285.png" alt="Ferr_0-1718897655285.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ferr_1-1718897671533.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1119720iE56829A62CEDD358/image-size/medium?v=v2&amp;px=400" role="button" title="Ferr_1-1718897671533.png" alt="Ferr_1-1718897671533.png" /></span></P><P>&nbsp;</P> Thu, 20 Jun 2024 15:37:37 GMT https://community.fabric.microsoft.com/t5/Developer/Time-Hierarchy-not-showing-correctly/m-p/4002413#M53516 Ferr 2024-06-20T15:37:37Z https://community.fabric.microsoft.com/t5/Developer/Time-Hierarchy-not-showing-correctly/m-p/4002936#M53528 <LI-CODE lang="markup">I have ensured Time Intelligence are turned on in the global settings</LI-CODE> <P>The recommendation is to always switch that off and use your own calendar table.&nbsp; There is no need to create a hierarchy, the visuals are smart enought to do that for you on the fly.</P> Fri, 21 Jun 2024 00:48:53 GMT https://community.fabric.microsoft.com/t5/Developer/Time-Hierarchy-not-showing-correctly/m-p/4002936#M53528 lbendlin 2024-06-21T00:48:53Z