Forum Discussion

Krcmajster's avatar
Krcmajster
Icon for Helper IV rankHelper IV
7 years ago
Solved

Clustered chart based on multiple columns

Hi,    I am have encountered and issue and can't find a solution.   I created the following table in Power BI:   2018 2019 2020 Headlease Rent 246 246 246 Market Rent 235 240 2...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Krcmajster,

     

    Please unpivot table in Query Editor mode.

     

    Then, please [Type] to X-axis and place [Year] to chart legend.

     

    Best regards,

    Yuliana Gu

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

If you shape your data as 'Year', 'Headlease Rent', 'Market Rent', 'Sublease Rent'.  It will go in a clustered column chart like you want it.

It's a small table so you can do that in Excel OR take what you already have and transpose it and add the year column. 

Once you have the data re-shaped, pull Year into Axis and the 3 rent types into Value.