NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

Learn How to Display A Monospaced Font in Power Query

1 Mins read

Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this font to a monospaced font? With 3 easy steps, you can quickly display a monospaced font with Power Query. For more Power Query Tips & Tricks you can check our highly appreciated Power Query Training for Beginners. With this training, you can easily solve data cleaning and data transformation problems.

Display A Monospaced Font With Power Query

Power Query has a solution for this also. If you want to use another font other than Unicode font then follow the below steps.

 

Step 1: Load data in Power Query

First, load the data in Power Query as you normally do. Then check the font style of the data. It is always uniform for all types of data as shown below.

DATA TABLE BEFORE CHANGING FONT

Step 2: Check the Monospaced option

To check the Monospaced option, go to –

View  >  Uncheck Monospaced option

DISPLAY MONOSPACED FONT

Step 3: Close and Apply

Now you will see that the Unicode font is changed to another type. You can close and apply the changes for the future.

AFTER DISPLAYING MONOSPACED FONT

 

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…