I have a date column in my data. When I drop the column into the visual it shows as a hierarchal date like normal (Separate columns for Year, Qtr, Month, Day). When I go to change it to a standard date format like (DD,MM,YYYY)in the visual, the visual throws an error.

"Column 'Date' in 'table' cannot be found or may not be used in this expression"

Any thoughts on how to fix this? I have never seen this before.

I have a date column in my data. When I drop the column into the visual it shows as a hierarchal date like normal (Separate columns for Year, Qtr, Month, Day). When I go to change it to a standard date format like (DD,MM,YYYY)in the visual, the visual throws an error.

"Column 'Date' in 'table' cannot be found or may not be used in this expression"

Any thoughts on how to fix this? I have never seen this before.

• date
• powerbi
• dax
• powerbi-desktop
• hierarchy

• I think this is a new bug that has been introduced as I'm seeing it too. – davidebacci Commented Nov 20, 2024 at 11:40

2 Answers 2

The best way I found to do this is use the "FORMAT" function in DAX and make a custom date format in the function.

For Example (Create a New Calculated Column)

FORMAT('Date', "DD-MMM-YY")

I am not sure why Power Bi is behaving the way it is, throwing errors when trying to change between hierarchy and standard format, but this is a good workaround.

In my opinion, the best way to deal with it is by using Power Query in Power BI and change it by using the option LOCALE. This will make all files have a standard format in the DATE column.