Forum Discussion

Regular Visitor

8 years ago

Solved

Matrix Column Headers - Measures before Dimension (SSAS)

Hi All Firstly, apologies if this has already been answered/covered in a previous thread; I've not managed to find anything thus far and did try to (probably wrongly) tag on to a different questi...

Need Help

Tutorial Requests

Anonymous
8 years ago
HI shanelthiggs,

I think you need some additional steps to achieve your requirement.

Steps:

1. Enter to query editor.

2. Choose 'Volume units' and 'Revenue Net', then use 'unpivot columns' feature to transfer them to attribute and value.
3. Save change and return to report view.

4. Drag attribute to column fields and value to value field.(notice: resort column filed and mark sure month column is in the bottom)

BTW, if 'Volume units' and 'Revenue Net' means measures, it is impossible to achieve your requirement. Current power bi can't use measure on row or column fields.

Regards,

Xiaoxin Sheng

shanelthiggs

Regular Visitor

8 years ago

Hi Anonymous - thanks for the reply.

I'm not sure that's going to work for us, as we're linking directly to a SSAS Cube for the data to form the matrix. The below might explain a little more what I'm hoping to achieve; effectively, get the values as columns.

In the third image, on the left hand side (1) is the output we're given, and the right hand side (2) is the output we'd like to be able to achieve.

Thanks

Shane

CurrentDesiredDesired Output