I was experimenting with Power BI report layout and wanted to build a report to mimic something written on paper with a pencil. The first thing that came into my mind was to use the custom font.
I wrote a random statement in MS word and tried out some fonts. The Bradley Hand ITC gave me a vibe of the handwritten font. So, I opened Power BI. build some very basic visuals and when I look into the font library, Bradley Hand ITC was not there, In fact the font library of power bi was very limited.
Luckily, there is a workaround available and we can handle this problem by creating a custom theme.
Step 1 :
Go to the view tab and click on the down arrow, then click on “Customize current theme”
Customize theme pop-up window will open, go to text option and change the font family of each of the four options i.e., General, Title, Cards and KPIs, and Tab headers
If we export the theme without changing the default text, the option to change the font on that specific class will not be available in the JSON file.
Click on apply after making changes in the font family
Step 2 :
Now again click on that little downward arrow. But this time select the save current theme. A pop-up browse window will open. Save the file in your desired location.
Step 3 :
Go to the location of the saved JSON file and open it. I used Notepad, a simple notepad will also do the job.
Replace the Aerial font with your desired font, in my case, it was Bradley Hand ITC, and save the JSON file.
To make this trick work, the desired font should be installed on your machine.
Step 4 :
Come back to power bi, click on that little down arrow and this time Browse the theme. Navigate the theme and click open
Result
Boom!!! The font has been applied
I hope this little trick will help you in your dashboarding.
Cheers!!!
Comments