Column Chart Sub-categories sort

Hi there,
I'm really stuck trying to sort these subvalues, by value, week, quarter and year 

Like:
Weeks | value
1          |  20
1          | 15
1          | 9
--------------
2          |  25
2          |  23
2          |  20

The main problem is that i just have access to the data through PBI dataflows not the original source so i could not use
an extra table or column.

I found that maybe add calculated fields could work or rankx, but still nothing works.

Thanks in advance.