Forum Discussion
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 was cut off. The dropdown doesn't "float above" or extend past the window borders like dropdowns in other Microsoft apps do (Edge, Word, Power BI Desktop itself), nor does it scroll like those dropdowns when they reach the edge of the monitor.
Additionally, the course content shows that the Date dropdown used to have its options in sub menu flyouts by category (Year, Month, Day, etc.) While maybe not the best solution, that is a solution and would work for me, but I cannot find a way to make the menu behave that way. I'm assuming that was in an older version of Power Query Editor.
Resizing the Power Query Editor window does allow the full dropdown to appear, so I can at least use it.
I've attached a screenshot of what the current behavior looks like on my computer. Screen resolution is 2560x1440, scaling is set to 125%, though the issue persists at 100%. At 100%, the text is so small that the full dropdown appears at my preferred window size, but if I make the window smaller, it is once again cut off.
12 Replies
My instructor replied back with the solution. If you go to File > Options and settings > Options > Report settings > Customize appearance (preview), there is an option for "Legacy". My desktop was set to "Light". Once I changed it to Legacy, the Power Query Editor behaved the way it did in the class materials.
I can definitely reproduce that behavior here. I believe it should be reported as a bug, since, without resizing the window, not all of the options under Date are accessible if one is not using the Legacy view.
I have not been able to locate a place to report this. Maybe someone else can.
Hi ronrsnfld
Please submit your concern by using the link below to raise an issue in the issue forum.
Issues - Microsoft Fabric Community
Thanks.
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 🌀.
Hi,
Which desktop version are with? Consider updating it to the lastest version and this is what i have.
Mine is very similar to MasonMA . The screenshot is with the smallest PQ editor window I can create:
And my version is also from Nov 2025 but seems to have a higher Version number than yours.
Version: 2.149.1203.0 64-bit (November 2025)
Perhaps your version was a QFE release and the version I have changed that behavior.
I'm running Windows. I didn't think there was a Power BI Desktop for MacOS...
