Forum Discussion
Solved
"Sorting Matrix Data Based on Slicer Selection
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 |
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 solutionBBF
1 Reply
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 solutionBBF