Table visual with Merged Rows when value is the same?

[ERing]

I have a table visual with business names and business address like shown below. I have been asked to merge the rows where the business name is the same so it looks like the bottom output. Does anyone know if this is possible with a table visual?

[Anonymous]

Your solution is so great danextian

Hi, @ERing 

I wish you all the best. Previously Super user have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[danextian · Accepted solution]

That is not possible with tables. Think of a table in Power BI as a table in Excel (not as formatted cells). But you should be able to do that with the matrix viz using either tabular or outline layout.

[lbendlin]

No, but you can do that with a matrix visual if needed.

Tell your stakeholders that Power BI is not Excel. If they need Excel formatting thye should consider continuing to use Excel.