How to visualize this data as a column chart?

[Dicko]

Hi all,

Probably very easy, but I cannot find it ...

I want this data...

unit	2000	2010	2020
sales	5	5	4
production		3	3
research	5	2	3

 visualized as follows...

 

How to do this?

Thanks.

[amitchandak · Accepted solution]

@Dicko , unpivot this table, then you should be able to take year as axis and unit as legend

https://radacad.com/pivot-and-unpivot-with-power-bi

[Jihwan_Kim · Accepted solution]

Hi, @Dicko 

The first step is to unpivot the table like below, then you can create the visualization like what you need.

The sample pbix file's link is down below.

https://www.dropbox.com/s/xgjcm4d2bllj4k6/Dicko.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[amitchandak · Accepted solution]

@Dicko , unpivot this table, then you should be able to take year as axis and unit as legend

https://radacad.com/pivot-and-unpivot-with-power-bi