Forum Discussion

Spooner's avatar
Spooner
New Member
10 years ago

Quartlery Data

Hello everyone,   I am a brand new user of PowerBI and have been experimenting wtih the platform for the last few days, so please excuse me if this question is rudimentary.   I have spent conside...
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

Spooner

To apply the quarters to X axis, you can follow below steps.

  1. Click edit query
  2. Select the 6 columns and unpivot
  3. Close the edit queries window and apply the change. In the powerbi desktop window, create a new column.
    Quarter = CONCATENATE( RIGHT('table'[Attribute],4), LEFT('table'[Attribute],2))
  4. Done

If you have any question, feel free to let me know.