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]. ...
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
BeaBF
Super User
Super UserMadhu7624 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