How to merge multiple rows in a Matrix Table?

[LyndonTomas]

For context, here is how the Matrix graph looks like in Power BI. As you can see there are multiple variants of "In-Progress". Is there a way to combine all of the "In-Progress" in 1 row? The Power BI is connected to a SharePoint List. The names of the Columns are "Status" and "Module".

[LyndonTomas]

Great this is very helpful! Thank you very much!

[bharath_v · Accepted solution]

Hi @LyndonTomas 

You can do this by transforming your data by going to:

Transform Data -> Add Column From Examples

Select your status column and add a column from example:
start typing In-Progress for In-Progress/UAT (for example) then the Power BI will automatically change for rest of the records.

I simulated your scenario as below:

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