Forum Discussion

PG1979's avatar
PG1979
New Member
8 months ago

Power Query Editor - Add Column > Date dropdown is cut off for small window sizes

I'm taking a course on Power BI and had to add some date-related columns to a calendar table in the Power Query Editor.  When I clicked on the Date dropdown, it extended to the edge of the window and...
General Comment
Need Help
Zanqueta's avatar
Zanqueta
Super User
8 months ago

Hi PG1979,

 

I guess you are right. 

 

Why does this happen?

  • The Power Query Editor uses a fixed-position dropdown that is constrained by the window size.
  • When the editor window is small, the dropdown cannot extend beyond its container, resulting in options being cut off.
  • The previous submenu design was removed in recent updates for consistency with other menus, but it introduced this limitation.

 

Current Workarounds

 

Use the formula bar or Add Column → Custom Column
Instead of relying on the dropdown, you can add date-related columns manually using M functions such as:

 

Date.Year([Date])
Date.Month([Date])
Date.Day([Date])

 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.