Bar chart - cluster x-axis and show bars for each cluster

[thomasuponor]

I am trying to create a bar chart with below clusters.
Blue = 2020
Orange 2021

The data comes from Excel:

Year	0-100.000	100.000-500.000	500.000-1.000.000	>1.000.000
2020	37,13%	40,0%	33,33%	33,33
2021	47,45%	36,41%	29,27%	20,59

So far I have done this:

Step 1: Query Editor

Step 2: Selected all the columns except Year and click on "Unpivot Columns" under Transform tab.

Now I am lost

 

[JustynaMK]

Hi Thomas,

Well, that's really it now all you need to do is to load your Query (Close & Apply button).

Then in Power BI Desktop do the following:

1. Add blank clustered column chart

2. Move your query's fields:

3. Enjoy your chart! You can go to Format section and change the colors, apply the labels etc.
You can also click on "Value" field and format it as a percentage ("Column tools"), just to make sure it is displayed properly.

 

[thomasuponor]

Hi Thomas,

Well, that's really it now all you need to do is to load your Query (Close & Apply button).

View attachment 32122

Then in Power BI Desktop do the following:

1. Add blank clustered column chart

View attachment 32120

2. Move your query's fields:

View attachment 32123

3. Enjoy your chart! You can go to Format section and change the colors, apply the labels etc.
You can also click on "Value" field and format it as a percentage ("Column tools"), just to make sure it is displayed properly.

View attachment 32124
View attachment 32125

View attachment 32126

You saved me again
I was placing "year" all other places than legend.
No it's working