Forum Discussion

urspalani's avatar
urspalani
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Power BI legend

Hello,   I am not able to add more than one Legend to 'Clustered Column Chart',I am trying to replicate the excel Power pivot chart,where i can add multiple Legend as you see below, Is anyon...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi urspalani,

     

    As you know, in PowerBI desktop, it is not allowed to add multiple legend to a chart. But you can add multiple categories in Axis. A workaround is to drag the two columns into Axis, then you can drill down the chart by changing the hierarchy. 

     

    Thanks,
    Yuliana Gu

     

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi urspalani,

 

As you know, in PowerBI desktop, it is not allowed to add multiple legend to a chart. But you can add multiple categories in Axis. A workaround is to drag the two columns into Axis, then you can drill down the chart by changing the hierarchy. 

 

Thanks,
Yuliana Gu