Power BI Grouping

[keanu1k]

Good afternoon, I am working with a data set that requires me to group columns together to display them with a splicer. However there is no function to directly group these throughout the data without changing the actual value. Any help?

[keanu1k]

	Price	Qty	Purchase price
Material 1	$            (13,000)	$                5,000	$               (8,000)
Material 2	5,000	2420	7420

 Pretty much i have 3 more variants of this similar formula Horizontally. Vertically there are more mateials . I would like to Group these three columns into one field so that when i splicer that field these values come up and so on and so forth for the other variations of this formula that appear later in the data sheet.

[Mahesh0016 · Accepted solution]

@keanu1k 
>> Go to Power Query Editor >> Select Column that you want Group by >> After selecting column >> In home tab you see group by icon >> click on >> grouping as per your requirement.

THANK YOU!!

[RocketRod]

Can you post some sample data with expected output and what you intend to do with the value?