Forum Discussion
How 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
4 Replies
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 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.
Click this one please 🙂
