Trying to create a pareto chart that will sort the earliest date when comparing two Months

[AppleUSN]

 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

[V-lianl-msft]

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.

[AppleUSN · Accepted solution]

I actually figured out the issue from another source.  It was easier than I expected.  I created this measure

first selected month RCC with time intelligence = CALCULATE(SUM('RCC History'[Value]), FIRSTDATE('Date'[Date]))

This allowed the first date I select on the slicer to be the driver for the sort order.  So, highest value for the First Date will be the order that all other dates selected will be ordered in.