Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically control legend on a chart

Hi!   I have over 45 items on my legend on a clustered bar chart, and all of them show up when the chart if displayed. Wehn I use a Year/Month filter to filter down the rcords , is it possible to s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The legend at the bottom still displays all the items .

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

Sorry Anonymous  but we'll need a lot more information to help you out in this case, as this is not standard behaviour.

 

If the total graph has been filtered, the legend should filter also as per my screenshot here. You can see the chart on top with no filter, and the chart below with filter. Legend has automatically updated. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Allison. I agree it should should filter out the legends as well and it does in my case as well when I use the Category filter, it does filter the lengends as well at the bottom , but when I filter by Year/month, that is when it stays the same.I get the entire list showing up on the legend.

     

    Thanks

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous 

     

    Right click Legend and deselect "Show items with no data". Besides, use measure below to deal with zero.

    Measure 2 =
IF ( [Measure] = 0, BLANK (), [Measure] )