How can I group the rows of these tables?

[HamidBee]

I am working with the following data:

Name	Value
Makeshift (10)	10
Central (5)	34
Makeshift (20)	66
Central (10)	78
Central(5)	26
Outer (19)	87
Makeshift (30)	40
Outer (19)	49
Outer(13)	45

I would like to plot the data on a bar chart but group the similar names together. So for exmample I would like to merge Makeshift (10), Makeshift (20) and Makeshift (30) together under the name Makeshift. I'd like to do the same for Outer and Central. After that I'd like to be able to drill down and actually show a detailed breakdown which will show Makeshift (10), Makeshift (20) and Makeshift (30). Does anyone have any ideas on how I can do this in Power BI Desktop?.

[CNENFRNL]

= Table.AddColumn(#"Changed Type", "Category", each Text.TrimEnd(Text.BeforeDelimiter([Name], "(")))

[HamidBee]

Thanks. Although I realised that some of the items I'm working with follow the pattern:

10 (Makeshift)

So when I use the M code above, it doesn't return a category name for these rows.

Assume I've plotted the bar chart for this. Name on X axis and Value on Y axis. How can I now drill down for each category so that I can see Name vs Value rather than just Category vs Value?.