Forum Discussion

urspalani's avatar
urspalani
Advocate 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 anyone have any idea,

 

Thanks,

 

 

 

  • 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

     

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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