Forum Discussion
Dynamically control legend on a chart
I am using a clustered chart which displays number of items, by Year/month and category of item. The Category of items are around 45 categories and that is the legend. In the legend it shows which color code the item is , since there re more than 45 categories , it does not fit all in one screen , so what I want to do is , when I use my Year/month filter on the report not drill down, basically it should remove all the categories that does not fall in that month /year , so only the legends corresponding displays on the report.
Community ChampionHow many categories fall in a given month? I'm still unclear why it's not working. Are you able to share a sample file via OneDrive link please?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
I was talking about the legend at the bottom of the screen, which shows all of them even when I use my Year/month filter, I want it to show only the ones that fall within that range.
- AllisonKennedy
So for example if you narrow down to 2021 October, what does it look like?
The legend at the bottom still displays all the items .