How to work with an already summarized data set?

[VictorMenezes]

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!

[Mkarwa-123]

@VictorMenezes Did I answer your question? Mark my post as a solution!

[Mkarwa-123]

@VictorMenezes Try to unpivot data in power query to get the result as excel chart.

[VictorMenezes]

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 · Accepted solution]

@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