Forum Discussion

StuartPQY's avatar
StuartPQY
Frequent Visitor
1 year ago
Solved

Measure and sort in matrix

Hello   I am hoping someone can help with my challenge.  I have looked online and I may be overcomplicating my issue.   Screen shot of dashboard           I have a measure that allows...
  • speedramps's avatar
    speedramps
    1 year ago

    You will laugh when I tell you the answer ....

     

    Change the data type from Text to a Number

     

    Text will sort alphabetically and left justify like this.

    The promlem will fix itself when you use a number instead of text

     

    Please click thumbs up and accept solution. Thank you !

     

    3

    301

    32

    4

    405

    43

     

     

     

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
1 year ago

Hi StuartPQY,

 

Please change the Actuals column data type as Whole Number.
Also, you can sort 2 columns by using shift key on keyboard and click one by one column to sort on multiple columns in a visual.
One more thing, if youare using Text columns in calculations in mesaures then there might chances of error as well.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X