Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter a legend on a visual?

Hi all,   I have a visual that has 3 filter tables applied: Position, Product, and Market Type.   I would like my legend to be filtered when selecting the various table filters. Is this possible?...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

This ended up not helping me too much. Is there a way to filter out the blank columns after a table filter has been applied? I think this would fix my legend issue. I tried using a visual level filter (show items when the value 'is not ' 0') but that ended up causing the entire visual to go blank regardless of what filters i selected.

 

Thanks,

 

Brian

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I thought i would circle around and give a final determination on this. A dynamic legend is a must in my book. But since Power BI doesnt have it, what i did is used colored shapes behind the position slicer options and then manually formatted the colors to be the same. 

 

This is still not ideal as i had to break 1 graph out into 3 graphs; otherwise one couldnt diferentiate the different products tied to the same resource. And there is a "understood rule" that the darker line is the DA postion while the lighter line is the RT position. Dynamic legends please.

Thanks,

 

Brian