Forum Discussion

Winniethewinner's avatar
Winniethewinner
Helper IV
4 years ago
Solved

Unpivot columns to create Dynamic Axis - data type becomes Text

Hi everyone, 

I'm unpivoting some columns of my data table, to create the Attributes which I can use for Dynamic Axis. One of Attributes is Month and I have values 1,2,3.....10,11,12 as whole number format in my original data table:

 

However, after unpivot, the data type becomes all Text, and this causes the sorting issues in my report: 

 

I'm wondering is there any other way to solve this other than adding another column and do something like If MN=1, then 01...... ? Thanks. 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Winniethewinner 

    Currently, it is not possible to have more than one data type in a column.

    Since you have text values in the column, you can only store these datas in type 'text'.

     

    Best Regards,
    Community Support Team _ Eason

4 Replies

    • Winniethewinner's avatar
      Winniethewinner
      Helper IV
      4 years ago

      It gives the error msg: 

       

      Also, I have different Attributes and the values are supposed in different formats - Month as whole number and others as Text. 

       

      But now the entire Value column is Text format. 

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Winniethewinner 

        Currently, it is not possible to have more than one data type in a column.

        Since you have text values in the column, you can only store these datas in type 'text'.

         

        Best Regards,
        Community Support Team _ Eason