Forum Discussion
How to work with an already summarized data set?
Hi there! I have a data set that is an output from our SQL tables that is already summarized. Table structure looks like this:
| Client | Activity A | Activity B | Activity C |
| A | 34,000 | 12,000 | 10,000 |
| B | 2,000 | 5,000 | 1,000 |
| C | 15,000 | 3,000 | 5,000 |
I already went to the columns and disabled summarize at the column but every visual I build is trying to summarize the column (which is giving me the total activity across client) where I'm trying to display the individual values (in cell B2,C2,D2) when looking at that row.
Below is how I have it setup in Excel, and I have a filter that looks at the activitgy by Client or aggregates by client or segment.
Happy to answer any questions!
VictorMenezes yes, I understand. This is your data.
After unpivot it will look lie same as your excel data. You can easily replicate that in power BI
4 Replies
Mkarwa-123Resolver II
VictorMenezes Try to unpivot data in power query to get the result as excel chart.
Hey Mkarwa-123 - the underlying data set is already summarized. The pivot/chart in Excel is just showing the visual output I'm trying to replicate in PowerBI.
- Mkarwa-123
VictorMenezes yes, I understand. This is your data.
After unpivot it will look lie same as your excel data. You can easily replicate that in power BI
- Mkarwa-123
VictorMenezes Did I answer your question? Mark my post as a solution!
