Forum Discussion

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Is it marked as date table? Right click on table Name. There is an option

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak SivaMani I got error "date column can't have gaps in dates"

    any idea how to solve that?

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      It's impossible to sue "date hierarchy" if you use "Direct Query" connection model.

      And  as tested, the date hierarchy cannot be displayed if this column is linked to other column.

       

      The impact of table relationships on date hierarchies

      1:1

       

      1:*

      (1: the date can use hierarchy; *: can't)

       

      *:*

       

      Smmarize: only one side of the date can use the date hierarchy. 

       

      So you may need to modify your table model.

       

      Best regards,
      Lionel Chen

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.