There is a neat feature in Tableau where you can create custom filters based on who logs into Tableau server via:
Server --> Create User Filter
However, when I try to do this on a worksheet that is not extracted (a direct live connection), the results act strangely.
I could set a user to only have access to two dimension values, but the worksheet shows NONE for that particular user.
If I set it to have access to all values, then ALL show up, as expected.
If I set it to have access to 1 value, then that 1 value shows up, as expected.
If I set it to have access to 3 values, then NONE show up.
... and so on.
If I extract the datasource, then the filters act perfectly fine.
Does anyone know why this behavior is happening?
could you please attach sample workbook, i wnat to check how the user filter set up.