Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
blake_leblanc
Advocate I
Advocate I

Unable to insert newline in formula bar with `Shift + Enter`

As of this morning, I am unable to use `Shift + Enter` to insert a new line when typing into the DAX formula bar.

 

Keyboard shortcuts in Power BI Desktop - Power BI | Microsoft Learn

 

Any ideas for how to fix? I've tried restarting, copy-pasting, etc.

1 ACCEPTED SOLUTION
blake_leblanc
Advocate I
Advocate I

Just tried the feature again after a long hiatus and I can confirm that newlines **NOW WORK** with the `Quick measure suggetsions` preview enabled, on desktop version 2.123.684.0 64-bit (November 2023)

View solution in original post

8 REPLIES 8
blake_leblanc
Advocate I
Advocate I

Just tried the feature again after a long hiatus and I can confirm that newlines **NOW WORK** with the `Quick measure suggetsions` preview enabled, on desktop version 2.123.684.0 64-bit (November 2023)

LG2000
New Member

Ctrl + Shift + Enter  => Enter new line in Dax formula

 

`CTRL + SHIFT + ENTER` is slightly different. Regardless of where the cursor is situated, it seems to always insert an entire new line.

Whereas `SHIFT + ENTER` will respect the cursor position.

 

So for example, if I wanted to break up the following statement into two lines, at the `_`:

 

`Measure = _Blah blah blah`

 

`CTRL-SHIFT-ENTER` will move the entire line down

 

```
_
Measure = Blah blah blah
```

 

While `SHIFT-ENTER` will only move the text after `Blah...` to the new line

 

```

Measure =
Blah blah blah
```

 

Does that make sense? Anything there I could explain better or may be wrong about?

 

---

And as a quick update to the topic, I just re-enabled the feature again and `Shift+Enter` still does not work as it does when the feature is *NOT* enabled.

JessieF
Advocate II
Advocate II

Has this issue been addressed yet?  I just discovered I'm having this problem now. Very inconvenient. 

It was still this way when I tried it again a couple weeks ago.

blake_leblanc
Advocate I
Advocate I

Quick update...

One of the things we changed this morning is we enabled `Preview Features -> Quick measures suggestions`

 

When I go back in and DISABLE this preview feature, I am able to `Shift + Enter` to create newlines as before.

 

So, at least on my end, it seems to be something related to this option. 

---

 

EDIT: Submitted this as feedback to the preview feature

ChrisMendoza
Resident Rockstar
Resident Rockstar

@blake_leblanc - what about 'Alt + Enter'?






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Tried that as well, but no luck. 

 

The only thing that "fixed it" for us at the moment was to disable the `Quick measure suggestions` preview feature we were playing around with this morning.

 

Which is interesting because not being able to use `Shift + Enter` applied to existing measures and newly created measures, as well as to those generated through the suggestion tool.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.