Forum Discussion
Helper IIUnable to replicate chart in Power BI
I am trying to replicate the following bar chart in Power BI but unable to do so. I can get the 'Year' into the Legend field but can only add one of Americas, Asia and EMEA in the Y-axis. It won't allow me to add all three.
Any help is appreciated.
Thanks
Shashank
Hi! Looks like the countries are your X Axis. I have created a similar chart with data from Adventure Works:
Country-Region is in the x-axis, year (fiscal year in my case) is in the Legend, and one of my measures is in Y-Axis
Hi sgupta22
This type of graph is available with power BI.You should put the Country on the X-axis.
The y-axis is for measure.I attached a PBIX you can download and follow my steps
If your table is in a structure that every country is in a separate column, you should unpivot the table before visualizing it.
please refer to the linked discussion with the example and guide :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
- audreygerred
Super User
Hi! Looks like the countries are your X Axis. I have created a similar chart with data from Adventure Works:
Country-Region is in the x-axis, year (fiscal year in my case) is in the Legend, and one of my measures is in Y-Axis
- Ritaf1983
Hi sgupta22
This type of graph is available with power BI.You should put the Country on the X-axis.
The y-axis is for measure.I attached a PBIX you can download and follow my steps
If your table is in a structure that every country is in a separate column, you should unpivot the table before visualizing it.
please refer to the linked discussion with the example and guide :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly