Forum Discussion
Solved
How do i count values from three different columns and show this on a tree map?
I have 3 columns (sent 1, sent 2 and sent 3) which each has the name of the company that a document was sent to. I'm trying to get power bi to count the total number of times that a name comes up in ...
When you load data (in power query), there is an unpivot feature. Before you will have
column 1, column 2, sent 1, sent 2, sent 3
after unpivoting you will have
column 1, column 2, attribute, value
attribute will contain the values
sent 1
sent 2
sent 3
the value column tells you where each were sent.
this is a better shape to do what you want.
MattAllington
Community Champion
Community ChampionWhen you load data (in power query), there is an unpivot feature. Before you will have
column 1, column 2, sent 1, sent 2, sent 3
after unpivoting you will have
column 1, column 2, attribute, value
attribute will contain the values
sent 1
sent 2
sent 3
the value column tells you where each were sent.
this is a better shape to do what you want.