I have loaded a tables with different dates onto Power BI. When I try to insert one of the date, Power BI automatically display the dates in Date Hiearachy. I would like to use the hiearachy for some filters, but I like to display the actual date eg 1 Mar 2025 in the table. How can I achieve this without turning off the date hierarchy option globally?

Hi epang Instead of the hierarahcy, select the Date column only from the dropdown

Import Date in Power BI Table | Microsoft Fabric Community

danextian
Super User
3 months ago
Hi epang

Instead of the hierarahcy, select the Date column only from the dropdown
krishnakanth240
Super User
3 months ago
Hi epang
Once you drag Date Hierarchy column into Columns pane of table visual, it shows column name as Date. Next to it you have down arrow where you can change it to Date. Select the Date Hierarchy column from data table level where you will not see Column tool tab on top. You can go to Model view and select Date column and change Date time format under properties
v-pnaroju-msft
Community Support
2 months ago
Thankyou, danextian and krishnakanth240 for your responses.

Hi epang,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by danextian and krishnakanth240 to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.