"Sorting Matrix Data Based on Slicer Selection

[Madhu7624]

Hi Everyone,

I want to sort the data in a matrix in a specific order. When I select a value in the slicer, 

Below is the raw data image :

The matrix contains Product and Value [Measure].

Raw Data

Slicer :

The order in which the products need to be sorted on the year value selected in the slicer.

Raw Data: 

Table
Product	Year	Value
P3	2023	100
P2	2023	200
P1	2023	300
P8	2023	40
P6	2023	100
P1	2024	200
P3	2024	300
P2	2024	40
P14	2024	100
P12	2024	200

slicer 

slicer

Year

2023

2024

Order needed 

Order Required [ when I select year in Slicer ]
2023	2024
Order	order
P1	P1
P2	P2
P3	P3
P6	P12
P8	P14

@BeaBF 

[BeaBF · Accepted solution]

@Madhu7624 Ok, so create a custom column in Power Query with this code:

=Text.Middle([Product], 1, 3)

then load data and make Sort Product a Whole Number type:

Now click on Product column and choose this new one in "Sort by column"

It will be ordered as you want.

If it's ok please accept the answer as solution

BBF