Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |