Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
To learn more about Power BI, follow me on Twitter or subscribe 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |