remove the date hierarchy for a single date field

Hi MikeSolvesBI ,

For example, you have created a calendar table for the dates 2023/1/1 to 2023/12/31 and you want to remove the date hierarchy for the date 2023/12/15?

If so,  Power BI is now unable to achieve what you need . You can submit an idea for it at   Ideas (powerbi.com)  and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

If not, you can have a try.

• 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.

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

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

• If you need to keep some of them and get rid of one right click on the field (Visualizations/Columns), check it and uncheck "Data Hierarchy".

  

   

   

Best Regards
Community Support Team _ Polly

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