Show Data only when any Selections are Made.

[Anonymous]

Hello,

In my dashboard I want to show Data such as Charts, Tables etcc what I have created only when I make any Selections through the Filters. When No selections are made the dashboard should be empty.

How do I achieve this?

TIA

[swuehl · Accepted solution]

Most charts have a property setting for a Show or Calculation condition which you can use to hide / not calculate your chart objects.

You could use a condition like

=If(IsNull(GetCurrentSelections() ),0,1)

[sunny_talwar]

Add below condition on the layout tab of your objects

Len(Trim(GetCurrentSelections)) > 0

[Anonymous]

Works. Thank you!

[Anonymous]

Hi, I found the solution. With your expression the charts are disappearing but when we make selections nothing is being shown.

I used =If(IsNull(GetCurrentSelections() ),0,1) to get what I was looking for as mentioned in one of the posts.

[sunny_talwar]

I had a typo, forgot to add () at the end of GetCurrentSelections function

Try this:

Len(Trim(GetCurrentSelections())) > 0

Should behave like what Stefan has provided, just avoids the if statement (which isn't a big deal, but I guess a very slight improvement )

Attaching a sample to look at.

Best,

Sunny