Forum Discussion

ODash's avatar
ODash
Regular Visitor
6 years ago
Solved

Combing Data Fields

Hi,   I'm relativly new to Power BI and am at the exploring stage to see if it can work for me.   I've got to a point of I know what I'd like to do, but not even sure if it's possible, so hopeful...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ODash ,

     

    You can also use the unpivot feature and remove empty feature in Query Editor.

    Please check the following steps.

    1. Select the tree columns and click unpivot.

    2. Click the buttom at the right of value column and click remove empty.

    3. Remove the Attribute column.

    The result would be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ODash ,

 

You can also use the unpivot feature and remove empty feature in Query Editor.

Please check the following steps.

1. Select the tree columns and click unpivot.

2. Click the buttom at the right of value column and click remove empty.

3. Remove the Attribute column.

The result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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