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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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 I
Advocate I

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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