Change Legend field in a stacked chart

[Anonymous]

Hi,

How to show a stacked bar with the correct legend when selecting the appropriate slicer?

 https://1drv.ms/u/s!AqDxOQKeFIy4cQ-Jup0QFXLdR-Q

Thank you,

Tamir

[v-yuezhe-msft]

@Anonymous,

Please check modified PBIX file attached below.

Regards,
Lydia

[Anonymous]

Thank you @v-yuezhe-msft

It is not quite what I need but never the less, a very interesting suggestion.

Thank you,

Regards,

Tamir, 

[v-yuezhe-msft]

@Anonymous,

Please check the modified PBIX file.

https://1drv.ms/u/s!AhsotbnGu1NolAhaZswpP4_EDdpU

Regards,
Lydia

[Anonymous]

Hi @v-yuezhe-msft

Thank you for the answer. However, I actually was not clear with my question 🙂

please find the following link to the better-explained challenge ( I hope).

https://basintamir-my.sharepoint.com/:u:/g/personal/tamir_tamirbasin_com/Ef7DHGMHEzNHut7GBXsoWOYByNP...

To sum it up :

1. There are about 20 employees who started to work in the company in 2015/2016/2017

2. Each employee got a review score every year (e.g. one who started in 2015 got scores in 2015,2016 and 2017.)

3. the difficulty is to show only 1 stacked column, the shows headcount by company (series) and by Performance (legends) wtha single selection of a year.

Thank you,

Tamir