Forum Discussion

shanelthiggs's avatar
shanelthiggs
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's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
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

cathgr's avatar
cathgr
New Member
4 years ago

Hello,

 

I am trying to do the exact same thing. Does the feature now exist for measures ? 

 

Referring to that : "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."

 

I am trying to do something easily done on Pivot Table in excel. When we have multiple "measures" and columns category: we just need to change the order of the "value" in the column to put it in first position. So our "values from measures" are shown as the first level of hierarchy.

Can we do something similar in a Matrix in Power BI?

Thank you!