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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
alwweb
Advocate II
Advocate II

Show Whitespace option in Power Query Editor of Power BI Desktop

First, I am using the July 2019 release.

 

I am trying to figure out what the Show whitespace option on the View tab of the Power Query editor does (if anything).  I click and unclick it, but I can's see any obvious changes.

 

Does anyone know what this does?  Thanks!

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

Hi @alwweb,

yes, there is a difference but you have to have a data sample in which you see a difference.

I have created a column containing "a" <carriage return> "b" - it should be rendered on two lines.
The same behaviour can be seen also with #"lf" or #"tab".

Capture.PNG

And with:

Capture2.PNG

View solution in original post

3 REPLIES 3
Nolock
Resident Rockstar
Resident Rockstar

Hi @alwweb,

yes, there is a difference but you have to have a data sample in which you see a difference.

I have created a column containing "a" <carriage return> "b" - it should be rendered on two lines.
The same behaviour can be seen also with #"lf" or #"tab".

Capture.PNG

And with:

Capture2.PNG

Thank you!  I would have never figured that out on my own.

Anonymous
Not applicable

I miss old-school documentation in cases like this. 😊

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors