Forum Discussion
SelectedValues will not filter on multiple values
Hi rwyoung01
You may create a column in Accounts table and link the two tables in relationship view.For example:
Key =
IF (
Accounts[AccountType] IN { "Business", "Chaplain" },
"A",
IF ( Accounts[AccountType] IN { "Other" }, "B" )
)
Regards,
Cherie
If I use a Chiclet Slicer that uses a measure to select the rows of data from the Account table that I want, I have to add that measure to every Object on the page, unlike the Visual filters for AccountType that make me select each AccountType manually but then filters all objects on the page or report that uses the Account table. I have included a screen shot. What I am trying to accomplish is similar to a feature in QlickView where a button can have a SQL like statement like 'Select in Field AccountType (Business,Chaplain,Church)' . Once this button is clicked on alll objects that use the Account table are then filtered.