Combine multiple measures into one column in one table

[Anonymous]

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

[v-yuta-msft · Accepted solution]

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