cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erhan_79
Post Prodigy
Post Prodigy

matrix table help

Hi there ;

 

i have a matrix table , in this table i add to value section "order quantity " , but it repeats based on "late " , early" and " on time " .

 

for "Delivery Qty " everything is ok , it should be repeat based on  "late , early and on time ",  but for "order quantity " i just want to see only in one column at the right  " , is it possible to do in matrix table or i need another visual 

 

could you pls help thanks in advance Capture1.JPG

 

1 ACCEPTED SOLUTION

@erhan_79 

I think you need to re-model your data.

Like, create two different tables

Table order quantity = FILTER(Table, Table[value section] = "order quantity")

and

Table Delivery Qty = FILTER(Table, Table[value section] = "Delivery Qty")

the add 'Table order quantity'[value section] as row, right to [Status] field


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
mahoneypat
Super User IV
Super User IV

You will need another visual.  All the measures will show for each category.  You could also try the "Show on Rows" feature in the Values format area to see if that gives you a better option.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


thank for info @mahoneypat  but do you know any other visual that i can show , i tried show on rows but it is not for me

@erhan_79 

I think you need to re-model your data.

Like, create two different tables

Table order quantity = FILTER(Table, Table[value section] = "order quantity")

and

Table Delivery Qty = FILTER(Table, Table[value section] = "Delivery Qty")

the add 'Table order quantity'[value section] as row, right to [Status] field


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors