Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Not wanted Date hierarchy column

I have Date column which has values like '2019-05-09 13:36:46.0980000' Whenever i use this column in  table visual Power BI is automatically creating date hierarchy which is not needed. I want to use this column as it is. 

 

Thanks,

Shubham

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi ,

     

    If the Hierarchy is getting created automatically then go to values under that filter for only Date and the Date Heirachry gets unselected there after you can select as per your requirement.I hope it helped you:-)

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi ,

     

    If the Hierarchy is getting created automatically then go to values under that filter for only Date and the Date Heirachry gets unselected there after you can select as per your requirement.I hope it helped you:-)

     

     

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Go to file/options/options and settings. 

     

    There are 2 settings, one under global data load and another under current workbook data load. Find the settings for auto time intelligence and turn them both off. Problem solved - permanently.