Forum Discussion

hueuro's avatar
hueuro
Frequent Visitor
2 years ago

metrix visual

hi

how can i change the Colums , field the below

 

Need Help

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi hueuro 
    I am not able to identify the query /issue you are asking. Can you explain a bit??

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi hueuro 

    You can not change the column directly in matrix, you can consider to create a new column in your table.

    e.g You column name is type(for the value A.B.C), create a calculated column in the table.

    Column =
SWITCH ( 'Table'[Type], "D", "B", "B", "C", "C", "D", [Type] )

    Then put the new column to the matrix column.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.