Table of Contents
The date hierarchy in Power BI allows users to easily group and organize data by different time periods such as year, quarter, month, etc. However, there may be instances where users do not want to use this hierarchy and instead view their data without any time grouping. To remove the date hierarchy in Power BI, users can simply go to the “Fields” pane, select the date column, click on the “Modeling” tab, and toggle off the “Date hierarchy” option. This will remove the date hierarchy and display the data in a flat format without any time grouping. For example, a user may want to remove the date hierarchy to compare sales data across different years without any time constraints.
The easiest way to remove a date hierarchy in Power BI is to click the dropdown arrow next to the date column of interest and check the box next to the name of the date column.
The following example shows how to do so in practice.
Example: How to Remove Date Hierarchy in Power BI
Suppose we have the following table named my_data in Power BI that contains information about total sales made by some company on various dates:
Now suppose that we would like to insert this table into a report in Power BI.
To do so, click the Report view icon on the left side of the screen:
Then click the icon named Table under the Visualizations tab on the right side of the screen:
Then drag the Date and Sales variables underneath the Columns label:
The following table will be created:
Notice that the Date column has been split into Year, Quarter, Month and Day columns.
To remove this date hierarchy, click the dropdown arrow next to Date under the Columns label, then click Date:
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: