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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors