Forum Discussion

vsantk's avatar
vsantk
New Member
8 years ago
Solved

bar charts

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     ...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

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