Merging cells in a data table

[DanAtMGT]

I am very interested to know if MS Power BI can merge individual cells within the actual main data section, not in a report…as these data cells (merged within the data set) create specific pivot charts.

This can be done easily in MS Excel but seems difficult in Power BI.

Hopefully, I can find answers here...

Thanks

Dan.

[DanAtMGT]

Hi Rita1983,

Thanks for your reply, and sorry for my late response to you till now.

I have approx 700 rows of data in Excel, with approximately 20 columns. I have some cells in one of two columns, which, when merged, create a specific chart. If the cells are not merged, the chart information is not accurate.

See the below screenshot showing the MGT Treatment Positive result compared to the MGT Report Positive result,

Can MS PowerBI accommodate the same Excel feature?

Hope this helps.

Cheers.

[Ritaf1983 · Accepted solution]

Hi @DanAtMGT 

Unfortunately, we cannot achieve the same functionality as the one shown in the image and using the same workflow as Excel. This is because the tool works differently. Excel operates at the cell level, and you can also "write and draw into it" like in other Microsoft programs. POWER BI, on the other hand, works with columns like Access and SQL, and the visualizations, including tables, inherit their characteristics from their definitions. Therefore, apart from conditional formatting options, which again require some logic, you cannot make changes at the "cell" level. This is why the "Merge & Center" function that exists in Excel is not available.

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

[v-yiruan-msft]

@Ritaf1983 Thanks for your contribution on this thread.

Hi @DanAtMGT ,

I'm not clear about your requirement. Could you please provide some raw data (exclude the sensitive info) in the excel file with Text format and the logic of column MGT Treatment Positive result and MGT Report Positive result?

For instructions on how to share the required information, please refer to the following link: 

How to provide sample data in the Power BI Forum

Best Regards

[Ritaf1983]

Hi @DanAtMGT 
Can you give an example of what are you trying to achieve?