- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI Grouping
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
>> 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!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
>> 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!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-17-2025 01:48 PM | |||
05-29-2025 04:27 PM | |||
12-01-2023 03:40 AM | |||
05-23-2025 12:56 AM | |||
05-01-2025 06:02 AM |
User | Count |
---|---|
12 | |
10 | |
8 | |
6 | |
6 |