Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
SaCvP125
Frequent Visitor

Merging Two Columns in Pivot Table

‎10-16-2017 12:21 AM

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 🙂

Labels:
Message 1 of 3
26,678 Views
0
2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

‎10-17-2017 02:00 AM

@SaCvP125,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 3 of 3
26,651 Views
0
Anonymous
Not applicable

‎10-16-2017 12:31 AM

Hi @SaCvP125,

 

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

 

Step 1Step 1Step 2Step 2Step 3Step 3 

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

 

Regards,

L.Meijdam

Message 2 of 3
26,674 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All