How to keep excluded values in bar chart?

[Akina0929]

Hi,

     My Requirement is when i select country in listbox the bar chart have to show selected country sales and excluded sales and selected value have to show different color or size.

Thank you in advance

Anji

[sunny_talwar]

May be use an expression like this:

Sum({<Country = >}Sales)

and a background color expression like this:

If(Sum(Sales) > 0, Red(), Blue())

[sunny_talwar]

Sample attached

[MarcoWedel]

Hi,

some similar solution:

Sunny's expression might suit your requirement better though, if your chart shall still react to selections in other fields than "country".

hope this helps

regards

Marco

[Akina0929]

Thank you

[MarcoWedel]

you're welcome.

please close this thread if your question is answered.

thanks

regards

Marco