5 Replies Latest reply: Feb 12, 2018 11:19 AM by Sunny Talwar

# Ignore a filter for the dimension colouring my graph

Hello,

I have a stacked bar graph that I am trying to get to ignore a filter on a different field. It has this formula normally:

count({<[Report Period]={'Rolling 30 Days'}>}[Broker Reference])

/count(total <Brand> {<[Report Period]={'Rolling 30 Days'}>} [Broker Reference])

which gives this graph:

However if I ignore any filters on the dimension Lapsed By using this formula

count({<[Report Period]={'Rolling 30 Days'},[Lapsed By]=>}[Broker Reference])

/count(total <Brand> {<[Report Period]={'Rolling 30 Days'},[Lapsed By]=>} [Broker Reference])

and then filter on a Lapsed By value the graph still shows the normal split but greys out segments that don't relate to this agent:

Is there a way to stop these from greying out? I am assuming it is because my second dimension that is colouring the graph is still being filtered on my Lapsed By selection, but don't know how to stop this.

Any solutions would be much appreciated!

• ###### Re: Ignore a filter for the dimension colouring my graph

You might be using an expression for color as well... in order to make sure that the colors don't go away, ignore  Lapsed By in your color expression also

• ###### Re: Ignore a filter for the dimension colouring my graph

I am using an expression for colour: by dimension [Reason], but as this is a dimension not a measure I don't know how to make it ignore Lapsed By ..

• ###### Re: Ignore a filter for the dimension colouring my graph

Something like this

Only({1} Reason)

• ###### Re: Ignore a filter for the dimension colouring my graph

Sorry, I'm trying to colour using a dimension not an expression, so can't use the Only() function as it's aggregate. If I change to colour using an expression and try this formula nothing gets coloured at all.

• ###### Re: Ignore a filter for the dimension colouring my graph

I am not sure what you have, but may be omarbensalem can help here