Forum Discussion
Syndicate_Admin
Administrator
AdministratorHow to create this double X-axis graph?
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. ...
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
coskuersanli
Resolver III
Resolver IIIHi 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_AdminThanks 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.