Forum Discussion

Reno_35's avatar
Reno_35
Frequent Visitor
7 years ago
Solved

Matrix : Ordering column when NO rows

hello all,   i feel so stupid but i can't find any answers to my simple problem.   i have a very simple matrix where i only use measures and columns. for the measures, i picked the option "value...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    I don't think you've done anything wrong here, I think you may have found an issue in the matrix visual in that once you have assigned a sort order based on one of the measures there is no way to turn off that measure based sorting. One work around that worked for me was to remove the measure that was being sorted and then re-add it.

     

    So in your case if you remove the [Search Result Views] measure from the matrix you should see the months go back to their alpha-numeric order, then you can add the [Search Result Views] measure back.

d_gosbell's avatar
d_gosbell
Super User
7 years ago

I don't think you've done anything wrong here, I think you may have found an issue in the matrix visual in that once you have assigned a sort order based on one of the measures there is no way to turn off that measure based sorting. One work around that worked for me was to remove the measure that was being sorted and then re-add it.

 

So in your case if you remove the [Search Result Views] measure from the matrix you should see the months go back to their alpha-numeric order, then you can add the [Search Result Views] measure back.

  • Reno_35's avatar
    Reno_35
    Frequent Visitor
    7 years ago

    d_gosbell,

     

    Thank you for the tip ! it worked perfectly :) i never would have thought about that i was stuck ahah

     

    the matrix visual should include a clear "sort by column" option.

     

    thanks a million again for the trick !!