Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new here, sorry if this a real easy one!
How do I control where/how the default filtering is applied?
For instance - I have a list box and when I click an item it filters everything on my dashboard - how do I make this filter one chart, but leave another one alone?
Also, when I click a bar in a chart, I don't want it to filter itself - this always leaves me with one big bar - clearly not desirable, so how do I prevent this?
Cheers
Tom
Look into using alternate states. This will allow you to have a filter apply to some things and not others. For the bar chart, you can select 'Read Only' on the General tab if you don't want users to be able to click to select.
Hi
Are you asking like this
For one chart, filters want to apply. but not for another one..
if so,
try like this,
=in expression use something like this
sum({1}sales) // it exclude all selections
sum({<Year=, Month=>}sales) // it exclude year n month field alone
2.Also, when I click a bar in a chart, I don't want it to filter itself - this always leaves me with one big bar - clearly not desirable, so how do I prevent this?
So for you, don't want to selection in field? am correct?
if so, use like this
=sum({1} sales)
Hope it helps
use alternative states and follow this video