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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

  • abner0's avatar
    abner0
    Frequent Visitor
    4 years ago

    I have a large amount of data with thousands of rows that is linked to other measures and visualizations. I suppose unpivoting will affect all these data? Is there an alternative that will keep my data intact since unpivoting will cause thousands of columns?

    • HotChilli's avatar
      HotChilli
      Icon for Community Champion rankCommunity Champion
      4 years ago

      abner0   start a new post (i.e. not on this thread) and put some detail in it please.  That's your best option to get help.