Merging Two Columns in Pivot Table

[SaCvP125]

Hi guys,

Is possible to merge two columns in Pivot Table? I've a Indicator which aggregates two values by priority and I want to show the two values on same column father.

Thanks 🙂

[v-chuncz-msft]

@SaCvP125,

Your requirement seems not very clear. A complete example might be better. You may first check the Matrix visual.

[Anonymous]

Hi @SaCvP125,

Through the 'Query editor' pane you can merge columns the way you want, see the steps below:

Step 1Step 2Step 3 

You can use the newly created calculated column in visualisations just like normal ones

Regards,

L.Meijdam