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.
Hello,
What would be the most suitable Visual to present the following information?
Values:
Planned Qtt
Production Qtt
Columns:
Weekday
Shift
Rows:
Machine
Product
Ideally, I would like to have a graph with Weekday and shift (by weekday) as columns headers and Machine and respective product as row headers.
Planned quantity and production qtt would be the values that I want to compare for each column (shift in weekday)/row (product in a machine).
Like the following:
Mon | Tue | Wed | Thu | Fri | ||||||||||||
N | M | A | N | M | A | N | M | A | N | M | A | N | M | A | ||
Machine A | Prod. 1 | 100 | 120 | 110 | 90 | 90 | 90 | 100 | 100 | 100 | 95 | 95 | 95 | 110 | 110 | 80 |
90 | 130 | 100 | 88 | |||||||||||||
Prod.2 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | |
100 | 105 | 90 | 93 |
Also, it would be perfect if I could format the background of the produced qtt: for instance, if Iproduced half of the planed qtt, half of the cell would be painted.
Thank you,
Patricia
Solved! Go to Solution.
Hi @Anonymous ,
We can use the following measure after create several Dim Table to meet your requirement:
Value = SUMX('Qtt',SWITCH([Qtt],"Planned",CALCULATE(SUM('Table'[Planned Qtt])),"Production",CALCULATE(SUM('Table'[Production Qtt]))))
Best regards,
Hi @Anonymous ,
We can use the following measure after create several Dim Table to meet your requirement:
Value = SUMX('Qtt',SWITCH([Qtt],"Planned",CALCULATE(SUM('Table'[Planned Qtt])),"Production",CALCULATE(SUM('Table'[Production Qtt]))))
Best regards,
Hi @Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |