Forum Discussion
Problem with showing visual correct. Some data shall be grouped and others split - How to?
Hi I have some data needs to present in a visual the following way;
| New category | Sum Value |
| Aa | 8 |
| Ab | 5 |
| A2 | 3 |
| B | 4 |
| C+D | 8 |
| E | 6 |
| F+G | 6 |
The data looks like this
| Category | Subcategory | Value |
| 1a | A | 8 |
| 1b | A | 5 |
| 2 | A | 3 |
| 2 | B | 4 |
| 2 | C | 5 |
| 2 | D | 3 |
| 2 | E | 6 |
| 2 | F | 4 |
| 2 | G | 2 |
I have used grouping and managed to combine C+D and F+G, but Im not able to split the A's in the same operation. I was hoping that I can do this without making a new column since the dataset is allready very large.
Any ideas? THanks:)
3 Replies
nor303 the only way I can think of adding a new column for grouping, or creating a dimension table with the grouping column and having a relationship with this table and using grouping from this new dimension table otherwise you will be making it super complicated for no reason. Adding a new column or table shouldn't be a big concern. How big is your table?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Hi thanks!
Its 60000 rows and 30 columns roughly. Im not sure how you mean I should do this? Will it be suffient with one new coumn? I tried to do this and write a dax with the help of chat gdp but it got all wrong. Is there an easier way?
nor303 I would recommend putting sample data in an Excel sheet with the example output and I will look into it. Your original post is only referring to two columns, so not sure if that is still the actual requirement though?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
