How to hide legend of a stacked column chart

[Anonymous]

Hi everyone,

i have been stuck with an issue on my stacked column chart:

The context:

I have a database and from that database I created the attached visual.

The problem:

When I filter on some specific projects, it happens that there is still the full legend (let's say 15 items) whereas for the chart displayed there are only 5 items over these 15

What I am trying to do:

I would like that, whenever I am filtering of any project, that the legend becomes the appropriate one (i.e., only the value concerned, not the full legend)

Do you have any idea on how I could do that?

I have been through Google but nothing worked for my case.

Wishing you all a great weekend,
lucas

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
We don't have this functionality built-in, but you can achieve it by generating the legend by yourself with conditional formatting. 

To achieve it i created a small table with blank value:

measure for conditional formatting according to the graph's color

used it to have cells by these colors :

switched off all elements of a table like grides / lines 
added a text box with a title to avoid place problems
and grouped everything together

Result with filtering :

pbix is attached

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Thanks for your answer, helps a lot!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
We don't have this functionality built-in, but you can achieve it by generating the legend by yourself with conditional formatting. 

To achieve it i created a small table with blank value:

measure for conditional formatting according to the graph's color

used it to have cells by these colors :

switched off all elements of a table like grides / lines 
added a text box with a title to avoid place problems
and grouped everything together

Result with filtering :

pbix is attached

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Thanks for your answer, helps a lot!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

Happy to help please accept my response as the solution to help the other members find it more quickly