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.
POWER BI FOR DUMMIES
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.
Step 2: Check the Monospaced option
To check the Monospaced option, go to –
View > Uncheck Monospaced option
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.
You can learn more :
- How to Add Comments in M using Power Query
- Top 5 Steps to do Comments In Query Steps
- Delete Steps Until End by Power Query
- Advanced Editor with Power Query