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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
kashifk
New Member

Post data of Store in another way

I have the following Data - a Sample

ItemSales Person NameSales
TieAndrew   500
TieBenett   400
TieRaees   300
BeltAndrew   100
BeltBenett   150
BeltRaees   280
ShoeAndrew   650
ShoeBenett   100
ShoeRaees   280

Now I want to put it this way

 AndrewBenettRaees
Tie                                500   400           300
Belt                                100   150           280
Shoe                                650   100

           280

I need this to present in this way, but I don't know how to do it in Power Query.  Thanks in Advance

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @kashifk 

You don't need to make changes to the data structure by PQ to present your data in the desired way.
We have a Matrix visual for it :
(if you don't need row / column totals you can switch them off

Ritaf1983_0-1694243754914.png

For more information about matrixes please refer:

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @kashifk 

You don't need to make changes to the data structure by PQ to present your data in the desired way.
We have a Matrix visual for it :
(if you don't need row / column totals you can switch them off

Ritaf1983_0-1694243754914.png

For more information about matrixes please refer:

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors