Forum Discussion

kilala's avatar
kilala
Resolver I
2 years ago

Table row sort by Order

Hi all, I created a table using formula below:

Detail_Columns = {
    ("A", NAMEOF('dim_A'[A]), 0),
    ("B", NAMEOF('dim_B'[B]), 1),
    ("C", NAMEOF('dim_C'[C]), 2)
}
 
And I have sort it by Order. When I put it as slicer,it comes out in right order.
 
I create a matrix table where i display the Detail_Columns as Rows. The problem is when I select something from slicer and not following the order, it also did not follow the order.
 
Let say, supposed I select B-->A-->C
it will come out column B-->A-->C. I want it to follow the order instead (A-->B-->C).
 
How do I fix this?
Need Help

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello kilala ,

     

    First of all, this is a field parameter you're talking about, so yes it would show in the selected order.

     

    but the question is why don't you select it in the right order, why select wrong order but you want it other than you selected.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote for my Community Mobile App Idea 💡

    • kilala's avatar
      kilala
      Resolver I
      2 years ago

      Hi Idrissshatila ,

      This is the feedback i got from user.Apparently they are selecting it in wrong order but they want to show it in correct order 😞 

       

      so, kind of want to prevent this to happen, if they select anything from the slicer i would need to auto arrange according to the order huhu