Forum Discussion
Solved
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 ...
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
Resolver II
Resolver IIVictorMenezes 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