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             $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.

  • 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

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    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