Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 3 columns [YYYYMO], [RCC], [Value]
I want to be able to compare the value of the RCC from each Month which is in YYYYMO (code for Year and Month). I was able to do this in a chart with a slicer to show Month A vs Month B but I would like to sort the RCC category from highest to lowest value of the lower Month that is selected in the slicer and also have the other month RCC sorted with it. In my screenshot below you can see that the pareto works but it is sorted strictly by the total sum of RCC overall and not by the highest RCC of the older month that I selected. The 2021 OCT 1008 qty should be the highest and both months sorted by 2021 OCT top 10 values.
YYYYMO | RCC | Value |
202001 | C-CAP-Capacity/manpower | 211 |
202001 | C-CSI-Customer Source Inspection | 1 |
202001 | C-DTL-Detail shortage | 5 |
202001 | C-ENG-Engineering | 266 |
202001 | C-FAI-FAI/FAIR | 21 |
202001 | C-GSI-GSI | 0 |
202001 | C-INV-Inventory shortage/lost/damaged | 2 |
202001 | C-L/T-Pull-in/Expedite/PO less than L/T | 1849 |
202001 | C-MAT- Customer Supplied Material shortage | 0 |
202001 | C-MAT-Material shortage | 18 |
202001 | C-MFG-Manufacturing design/manufacturability | 41 |
202001 | C-PNC- Rev Change/obsolescence | 0 |
202001 | C-PNC-Part revision/superseded/obsolescence | 21 |
202001 | C-PO CONFIRMATION | 0 |
202001 | C-POM-PO Maintenance/edits | 187 |
202001 | C-PRO-Process approval/FPA/process inadequacy | 33 |
202001 | C-QMS-Quality/Quality Assurance | 20 |
202001 | C-REC-Receiving dock issue | 9 |
202001 | C-RWK-Rework/repair/scrap | 41 |
202001 | C-SUB-Sub-tier/OP delay | 3 |
202001 | C-UNCONFIRMED PO | 0 |
202001 | C-UNK-Unknown | 5 |
202001 | S-CAP-Capacity/Machinery-Manufacturing | 0 |
202001 | S-CAP-Capacity/manpower | 917 |
202001 | S-CSI-Customer Source Inspection | 15 |
202001 | S-DTL-Detail shortage | 13 |
202001 | S-ENG-Engineering | 24 |
202001 | S-FAI-FAI/FAIR | 4 |
202001 | S-INV-Inventory shortage/lost/damaged | 19 |
202001 | S-L/T-Pull-in/Expedite/PO less than L/T | 57 |
202001 | S-MAT-Material shortage | 90 |
202001 | S-MCH-Machine downtime/maintenance | 4 |
202001 | S-MFG-Manufacturing design/manufacturability | 7 |
202001 | S-PNC-Part revision/superseded/obsolescence | 9 |
202001 | S-PRO-Process approval/FPA/process inadequacy | 7 |
202001 | S-QMS-Quality/Quality Assurance | 89 |
202001 | S-RWK-Rework/repair/scrap | 84 |
202001 | S-SUB-Sub-tier/OP delay | 90 |
202001 | S-TLG-Tooling shortage/repair/maintenance | 0 |
202001 | S-UNK-Unknown | 211 |
202002 | C-CAP-Capacity/manpower | 45 |
202002 | C-CSI-Customer Source Inspection | 2 |
202002 | C-DTL-Detail shortage | 22 |
202002 | C-ENG-Engineering | 138 |
202002 | C-FAI-FAI/FAIR | 11 |
202002 | C-GSI-GSI | 0 |
202002 | C-INV-Inventory shortage/lost/damaged | 1 |
202002 | C-L/T-Pull-in/Expedite/PO less than L/T | 847 |
202002 | C-MAT- Customer Supplied Material shortage | 0 |
202002 | C-MAT-Material shortage | 13 |
202002 | C-MFG-Manufacturing design/manufacturability | 37 |
202002 | C-PNC- Rev Change/obsolescence | 0 |
202002 | C-PNC-Part revision/superseded/obsolescence | 15 |
202002 | C-PO CONFIRMATION | 0 |
202002 | C-POM-PO Maintenance/edits | 184 |
202002 | C-PRO-Process approval/FPA/process inadequacy | 11 |
202002 | C-QMS-Quality/Quality Assurance | 1 |
202002 | C-REC-Receiving dock issue | 3 |
202002 | C-RWK-Rework/repair/scrap | 20 |
202002 | C-SUB-Sub-tier/OP delay | 0 |
202002 | C-UNCONFIRMED PO | 0 |
202002 | C-UNK-Unknown | 7 |
202002 | S-CAP-Capacity/Machinery-Manufacturing | 0 |
202002 | S-CAP-Capacity/manpower | 461 |
202002 | S-CSI-Customer Source Inspection | 1 |
202002 | S-DTL-Detail shortage | 2 |
202002 | S-ENG-Engineering | 14 |
202002 | S-FAI-FAI/FAIR | 18 |
202002 | S-INV-Inventory shortage/lost/damaged | 4 |
202002 | S-L/T-Pull-in/Expedite/PO less than L/T | 25 |
202002 | S-MAT-Material shortage | 67 |
202002 | S-MCH-Machine downtime/maintenance | 10 |
202002 | S-MFG-Manufacturing design/manufacturability | 10 |
202002 | S-PNC-Part revision/superseded/obsolescence | 0 |
202002 | S-PRO-Process approval/FPA/process inadequacy | 2 |
202002 | S-QMS-Quality/Quality Assurance | 31 |
202002 | S-RWK-Rework/repair/scrap | 45 |
202002 | S-SUB-Sub-tier/OP delay | 44 |
202002 | S-TLG-Tooling shortage/repair/maintenance | 5 |
202002 | S-UNK-Unknown | 67 |
Solved! Go to Solution.
I actually figured out the issue from another source. It was easier than I expected. I created this measure
Hi @AppleUSN ,
Try to sort axis by the value:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I actually figured out the issue from another source. It was easier than I expected. I created this measure
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |