Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Hierarchy created automatically

Hi 

 

When I imported my dataset, PBI automatically changes the Date into Date Hierarchy. But I just want dates (i.e 2022-09-01). How can I change it to normal dates. 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    After adding the date column to a visual, click on the down arrow beside the date value in the visual's columns, and select date rather than hierarchy.  You'll see that Hierarchy is selected by default

     

    Note that the name of the column will be whatever the column is called (sounds obvious).  So you aren't looking for an option in the menu called Date, it'll be whatever the column is called e.g. here, my column of dates is called Banana so I need to select Banana rather than Date Hierarchy

     

    regards

     

    Phil

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi Anonymous 

     

    After adding the date column to a visual, click on the down arrow beside the date value in the visual's columns, and select date rather than hierarchy.  You'll see that Hierarchy is selected by default

     

    Note that the name of the column will be whatever the column is called (sounds obvious).  So you aren't looking for an option in the menu called Date, it'll be whatever the column is called e.g. here, my column of dates is called Banana so I need to select Banana rather than Date Hierarchy

     

    regards

     

    Phil