Forum Discussion

MykytYla's avatar
MykytYla
Frequent Visitor
1 year ago
Solved

Append columns from 1 table for using in visual Slicer

Dear community I ask your advice. I have table with two addresses and I want to append these two addresses just for using in the slicer and map. Is it possible? Thank you in advance. I need Slicer ...
Append columns Slicer
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi MykytYla 

     

    Please try this:

    In the Power query, select the LE_address and Office_address column and click the Unpivot Columns in the Transform pane:

    Then remove the Attribute column:

    Change the name of the values column and the result is as follow:

     

     

    Best Regards

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

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
1 year ago

Hello MykytYla,

 

Can you please try this approach to create a new calculated column that combines these two columns:

Combined Address = 
IF(
    ISBLANK('YourTable'[Office_address]),
    'YourTable'[LE_address],
    'YourTable'[LE_address] & " | " & 'YourTable'[Office_address]
)

Hope this helps.