Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cannot move calculated column in matrix

  Hi, I have a matrix displaying production data as is shown in the uploaded screenshot.  The outstanding quantity column is a calculated field and ideally I want it placed after the status ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    It couldn't be achieved that move the column place after [total] column in power bi for now. It could only be adjusted in "attribute" area.

    and for second question, The calculate column couldn't appear in Edit Queries. Because Calculate column is based on DAX language and data model, but column in Edit Queries is based on M language and data soure.

    https://radacad.com/m-or-dax-that-is-the-question

     

    If you still want to pivot it, you could use same logic create a custom column in edit queries then pivot.

     

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

It couldn't be achieved that move the column place after [total] column in power bi for now. It could only be adjusted in "attribute" area.

and for second question, The calculate column couldn't appear in Edit Queries. Because Calculate column is based on DAX language and data model, but column in Edit Queries is based on M language and data soure.

https://radacad.com/m-or-dax-that-is-the-question

 

If you still want to pivot it, you could use same logic create a custom column in edit queries then pivot.

 

Best Regards,

Lin