bar charts

[vsantk]

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.

[v-piga-msft · Accepted 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