How to create this double X-axis graph?

[Syndicate_Admin]

Hello.

I have created this graph in Excel and I would like to do it in powerBI, but I have tried but I do not succeed, for each year I have two columns of data.

Any ideas?

Greetings and thanks.

[coskuersanli · Accepted solution]

Hi @Syndicate_Admin ,

You need to convert your data to something like below one. Use Year and Category columns in axis and Country in legend. Lastly, sort the visual by your columns (not measure) 🙂

Country	Year	Category	Value
SPAIN	2017	Target	600
SPAIN	2017	Executed	500
SPAIN	2018	Target	600
SPAIN	2018	Executed	555

[Syndicate_Admin]

Thanks for the reply, but I can't do it.

I have created a table as directed.

I have designed following in their footsteps, but the result is not what I want. The last step of not measuring I do not understand well, could I clarify and say that it fails me?

Thanks a lot.

[coskuersanli]

Click this one please 🙂

[Syndicate_Admin]

Ok.

Now yes, thank you very much.