Convert table columns from left to right

[ayaasfour]

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

[v-jingzhang]

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.

[ayaasfour]

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?

[ayaasfour]

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

[ryan_mayu]

@ayaasfour 

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

[ayaasfour]

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

[ayaasfour]

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

[ryan_mayu]

@ayaasfour 

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

then remove the last column