Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

How to design an invoice in Power BI?

Is it possible to design an invoice in Power BI?

I'm not talking about the tabular part which contains the products, their quantities and the prices, but more about the single fields such as what you see in the screenshot

Invoice.png

 

Thank you,

Hayman

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

Hi @haymanezzeldin,

 

For the single fields, you can make use of the Card visuals in Power BI, and have them display a custom measure that you've concatenated with text. For example, with a custom measure your card could include advanced DAX functions and display something like, "Total revenue this year: $5bn" or "Progress on unit sales this year:" and then add the number that represents the progress. 

 

card01.PNG

 

Regards

View solution in original post

2 REPLIES 2
v-ljerr-msft
Employee
Employee

Hi @haymanezzeldin,

 

For the single fields, you can make use of the Card visuals in Power BI, and have them display a custom measure that you've concatenated with text. For example, with a custom measure your card could include advanced DAX functions and display something like, "Total revenue this year: $5bn" or "Progress on unit sales this year:" and then add the number that represents the progress. 

 

card01.PNG

 

Regards

Phil_Seamark
Employee
Employee

Power BI isn't really optmised for this kind of report.  You could produce something by laying out your measures and using the Grid or Matrix visual for your detail lines, but you will run into issues around printing etc.  

 

Reporting Services is probably a more suited product for this.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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