Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Want to show multiple y axis on 1 bar chart. Data format is as follows:
Region 2018Q1 2018Q2 2018Q3 2018Q4
NA $100k $125k $125k $50k
LA $20k $15k $25k $0
EU $200k $150k $100k $50k
N. Asia $200k $200k $200k $200k
Want the quarters to be individual bars with labels and regions as stacked. I can do this in excel with pivot charts, but can't figure out how to do it in power bi.
Solved! Go to Solution.
Hi @vsantk,
Want to show multiple y axis on 1 bar chart. Data format is as follows:
Want the quarters to be individual bars with labels and regions as stacked. I can do this in excel with pivot charts, but can't figure out how to do it in power bi.
You could follow the steps to get your excepted output.
1. Unpivot the column in Query Editor.
2. Create the Stackted bar chart like below.
Hope it can help you !
Best Regards,
Cherry
Hi @vsantk,
Want to show multiple y axis on 1 bar chart. Data format is as follows:
Want the quarters to be individual bars with labels and regions as stacked. I can do this in excel with pivot charts, but can't figure out how to do it in power bi.
You could follow the steps to get your excepted output.
1. Unpivot the column in Query Editor.
2. Create the Stackted bar chart like below.
Hope it can help you !
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |