Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

sort by column

hi is there any way to sort table\card\slicer by column that are not in the table? i have a 'month' column in 1 for january,2,3,4... i cannot create new column by using format(month,mm) because of ...
Need Help
jirineoral's avatar
jirineoral
Icon for Post Patron rankPost Patron
10 years ago

Greg_Deckler

This idea occured to me too. But Enter data is grayed out when you're using live connection 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Can you use the "hidden column" trick. Basically, add both the month name and the month number as columns in the table and then shrink the month number column down so you can't see it and then use the visualization controls "..." to sort by the hidden column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    MP_123 Are you hitting a Table or View in your DQ? If you use Views when accessing data via DQ you can easily handle any additional data requirements for your modeling from the source database.

  • Haider121's avatar
    Haider121
    Frequent Visitor
    9 years ago

    problem with that is if you pin this visualisation to a dashboard the hidden month number column unhides it self!