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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.