How to Remove Date Hierarchy in Power BI (With Example)


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:

Power BI remove date hierarchy

This will cause the actual dates to be shown in the table of the report instead of the date hierarchy:

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Convert Date to Text
Power BI: How to Get Day of Week from Date
Power BI: How to Convert Date to Month and Year Format

Leave a Reply

Your email address will not be published. Required fields are marked *