Forum Discussion

ayaasfour's avatar
ayaasfour
Frequent Visitor
5 years ago

Convert table columns from left to right

Hey ,

I need to convert Matrix columns from left to right as I view table in arabic mode ,

I need to convert this

 

date in arabic col 1 col 2 col 3

 

into

col 3 col 2 col 1 date in arabic

Any help please

Need Help

6 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    ayaasfour 

    maybe you can try group by in PQ,grouping from the last column to first column. At last, delete the new column.

    • ayaasfour's avatar
      ayaasfour
      Frequent Visitor
      5 years ago

      Can you explain more as I do not understand what I should do precisely?

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        ayaasfour 

        not sure if we have a better solution for this. here is just a workaround for you.

        then remove the last column

  • ayaasfour's avatar
    ayaasfour
    Frequent Visitor
    5 years ago

    Can you explain more as I do not understand what I should do precisely?

  • ayaasfour's avatar
    ayaasfour
    Frequent Visitor
    5 years ago

    I dont have static columns I have just column numbers and row numbers and values and I draw matrix by this information. So i can not access on specific columns. , iS there is any solution?

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi ayaasfour 

     

    Suppose you have a matrix like this

     

    Do you mean you want to convert it into below format? (Date is a Rows field, aa/bb/cc are values in Column1 which is a Columns field)

    cc bb aa Date
    30 20 10 1/1/2021
    30 20 10 2/1/2021
    30 20 10 3/1/2021

     

    If yes, this is not supported in Power BI at present. 

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.