Non-associated Part of Pie Outgrayed

[fred_s]

Hi,

I'm looking for examples or best practices on how to get part of a Pie Chart Outgrayed after Selections.
After selecting Asia, I'd like to see 60% colored Asia and 40% gray.

Suggestions?

Has to be something like this ..

[swuehl · Accepted solution]

Maybe like attached?

[fred_s]

Hi Swuehl,

Exactly what i meant.
Thanks!

[mikecrengland]

I love this.

As an add-on, I would make the expression something like

=sum({<Region *=>} Population)

so that it can react to other filters. And then sort on expression to keep the selections next to each other:

=if(match([Region],concat(distinct [Region],',')),

       1,2)

mike

www.fortunecookiebi.com