NEW! FREE 1 hour Data Cleaning Course for Beginner Users Watch now 

Power BITutorials

Steps to Format Columns Using Power Query

1 Mins read

Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase, etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature.

Format Columns By Power Query

Step 1: Select Columns for Formatting

As shown in the below picture, the data table contains employee data where employee names are given in the lower case. To format these names we have to first select the entire column.

SELECT COLUMN FOR FORMATTING

Step 2: Capitalize each word for the selected column

To capitalize each word in Power Query, go to-

Transform  >  Text Column  >  Format  >  Capitalize Each Word option

CAPITALIZE EACH WORD FOR SELECTED COLUMN

Step 3: Close & Apply

After you get the expected result as shown in the below picture, click on the Close & Apply button to save the changes.DATA TABLE AFTER FORMATTING COLUMN

You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…