How to remove Date Hierarchy

Hi lavdeep 

Go to  File --> Options and Settings --> Options --> Current File -> Data Load 

and turn  off 'Auto Date/Time' (under Time Intelligence)

Sorry wrong advise.... actually when you drag it into values, you can right click and select the date name instead of the Date Hierarchy - then it will display as a single date.

If you turn the auto date stuff off.. you would then have to have your own date tables.