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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
tksnota
Post Patron
Post Patron

Need Help in Using Matrix Table in Power BI

Hi,

 

I created a matrix table using debtor code as data on the row. but upon adding data on the values like terms, currency, invoice numbers and other things  the matrix provided me first, sum, count, etc. which i don't really needed (see second screenshot).

 

I just want to get the exact data from the first screenshot when add them on the values of the matrix table.

 

is this possible?

 

tksnota_0-1718102937722.png

 

tksnota_1-1718103041558.png

 

 

2 REPLIES 2
tksnota
Post Patron
Post Patron

i had a separate power bi using table but i prefer to use matrix. is it not possible to create measures in matrix to address my requirements?

mohitkumawat
Super User
Super User

Hi @tksnota ,

Instead of using matrix Visual use Table Visual. 
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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