Display N/A until

[alemberg]

Is there a way to have a KPI display as N/A until a user select something from either a dropdown or within another visualization. As an example Total Returns N/A until the user selects a specific Fund or Region

[sunny_talwar · Accepted solution]

May be like this:

If(GetSelectedCount(Fund) = 0 and GetSelectedCount(Region) = 0, 'N/A', Expression)

UPDATE: You might need to play around with the Formatting of the KPI though