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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
JintePomper
Frequent Visitor

Power Bi custom font

Hi,

 

I have a question regarding importing a custom font. The font I would like to install is called "Libre Barcode 39". I tried all the methods described online, but somehow it is not working for this specific font. It does not show a barcode, but just a regular font. For other custom fonts it did work. I do have this font installed on my PC. Do you have a suggestion what else I could try? 

1 ACCEPTED SOLUTION

Hi @JintePomper ,

 

From official documents, the barcode data category is used to filter report by scanning the barcode in real world. For example, the corresponding product number of a barcode is 7290010237530, also there is a productNo field in desktop containing this value. When we scan the barcode of the real product, we can view its related report generated in Desktop. For details, please have a look at this video.

 

If you want to display barcode in Power BI, please using the barcode api instead of qrcode. https://github.com/metafloor/bwip-js/wiki/Online-Barcode-API 

 

This is my test, I add a calculated column:

Barcode API = "http://bwipjs-api.metafloor.com/?bcid=" & "code128&text=" & [Barcode]

vkkfmsft_0-1640842112593.png

 

Then set the data category of [Barcode API] as Image URL.

 

vkkfmsft_1-1640842194905.png

vkkfmsft_2-1640842291321.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

6 REPLIES 6
v-kkf-msft
Community Support
Community Support

Hi @JintePomper ,

 

I think you do not need to install custom font, because in Power BI Desktop, you can also categorize a column as Barcode. These are the barcode formats Power BI recognizes if you can tag them in a Power BI report:

  • UPCECode
  • Code39Code
  • A39Mod43Code
  • EAN13Code
  • EAN8Code
  • 93Code
  • 128Code
  • PDF417Code
  • Interleaved2of5Code
  • ITF14Code

Then on the Column tools tab, select Data Category > Barcode.

 

image.png

 

Refering: Tag barcode fields in Power BI Desktop to enable barcode-scan filtering in the mobile apps 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Winniz,

 

Thank you for your response! I indeed tried that out, but in the report the barcodes are not shown as barcodes, but just as numbers. I need to display the codes as barcodes in the report, so the client can scan the codes from the report. Do you know how I can implement that?

Kind regards,

 

Jinte

Hi @JintePomper ,

 

From official documents, the barcode data category is used to filter report by scanning the barcode in real world. For example, the corresponding product number of a barcode is 7290010237530, also there is a productNo field in desktop containing this value. When we scan the barcode of the real product, we can view its related report generated in Desktop. For details, please have a look at this video.

 

If you want to display barcode in Power BI, please using the barcode api instead of qrcode. https://github.com/metafloor/bwip-js/wiki/Online-Barcode-API 

 

This is my test, I add a calculated column:

Barcode API = "http://bwipjs-api.metafloor.com/?bcid=" & "code128&text=" & [Barcode]

vkkfmsft_0-1640842112593.png

 

Then set the data category of [Barcode API] as Image URL.

 

vkkfmsft_1-1640842194905.png

vkkfmsft_2-1640842291321.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

This worked for me as well.  I did notice is the barcode images are random heights.  Is there a fix for this? I tried the scaleY & ScaleX variables but didn't seem to help.

Dear Winniz, 

 

Thank you very much for your help! This solution worked for me! You have saved me a lot of time and trouble 🙂

 

Kind regards,

 

Jinte

This is realy cool!

I just replaced code128 by code39 since I noticed he mentioned Libre Barcode 39 and it is working.




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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