Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Combine multiple measures into one column in one table

Hi,

 

I have 3 single-row measures and I want to show them in a table one below another. I've only managed to show them in a single row table in 3 separate columns but I'd like to "un-pivot" them into one column (kind of "union all" exercise).

 

Any ideas?

 

Thanks,

Artur

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi arturosso,

     

    Measures are created in report level so measures can't be unpivot. Only columns in data model can be unpivot, to unpivot columns in power bi,  click Query Editors-> Transform-> Upivot columns.

     

    Regards,

    Jimmy Tao

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi arturosso,

     

    Measures are created in report level so measures can't be unpivot. Only columns in data model can be unpivot, to unpivot columns in power bi,  click Query Editors-> Transform-> Upivot columns.

     

    Regards,

    Jimmy Tao