Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Merge cells on Table chart

I am aware of the merge options available in power bi while importing the data but want to check, Did any one merge the cells in the table chart ?  I have requirement to merge the cells if the values present in the same column are same. 

 

 

Thanks,

Ganesan k.

5 REPLIES 5
Anonymous
Not applicable

What do you mean by Merge of cells? Can you explan with sample data?

 

Thanks

Raj

Anonymous
Not applicable

Hi Rajendran, 

 

Say for example if i get source in the below format 

 

Source   
NameUnits1Units2 Units 3
Raj103050
Raj113151
Raj123252

 

I want the output to be like  below. 

 

NameUnits1Units2 Units 3
Raj103050
113151
123252

 

Thanks,

Ganesan k.

Anonymous
Not applicable

11, 12 are Units, but why do you want to display under Name column? Its misleading?

Anonymous
Not applicable

I have just provided name as example. You can consider any text column present in the first column and it has be merged like how do we do in excel file. Is it possible?

 

 

Thanks,

Ganesan k.

Anonymous
Not applicable

Not as per my knowledge. But lets see if we get any other response.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.