Filter not working, but filter on page works

[dbegus]

Using a data set of values ranging from -20,000 to 20,000 I'm trying to get a visual all on one page that shows the data in 3 different formats for reviewing data.

1. Gross values: Returns total values for everything that is >0

2. Credit values: Returns total values for everything that is <0

3. Net Values: Returns total values for everything

Issue i'm running into, is that the filter on visual is not changing the data, but the filter on page is working. But since I have to use filter on page I can't show all 3 formats above since I can only filter on page by 1 of the requirements above. Is there any way to use filter on visual, the data I'm referencing isn't a custom column just pure data pulled in from tables.

[amitchandak]

@dbegus , A visual level filter will not go beyond page level filter.

You can three visual level filter or you can have measures like

Sumx(filter(Table, Table[value] >0), [Value])

Sumx(filter(Table, Table[value] <0 ), [Value])

Sum(Table[Value])

[dbegus]

Thank you, I'll go down the formula route, was hoping there was something I was missing with the visual filters.

One note: when working with the visual filters I made sure to have page filters not in effect, my apologies in hindsight the screenshot I submitted was not accurate. I found it weird that the visual filters wouldn't change the results but the page filters would.