Filter Multiple Column

[Anonymous]

Hello ,

i want to create a slicer , which will give me the possibility to choose only the columne i want , for example for the "Budget" i have 3 columns the same for "BOP" , i need to create a filter [ BOP , Budget ] when i choose one , it shows me only the columns associated ( whene i click Budget , the 3 columns of BOP diseappear )

[BA_Pete]

Hi @Anonymous ,

Put all of your columns/measures into a Field Parameter.

Create a Parameter Group, where you assign each column/measure to either Budget or BOP.

Add your Field Parameter as the table columns, and add the Parameter Group to a slicer.

Pete 

[Anonymous]

Thnaks a Lot ,

it works

one question please , it works for a simple Table , when i choose matrix it not works

[Anonymous]

i try to create a parameter but it didn't work ;

can u show me please how to create a Parameter Group ?

[BA_Pete · Accepted solution]

Put ALL of your BOP and Budget columns that you want to be viewable in the table into the initial field parameter.

In the Data list on the right, find your Field Parameter, expand it, then right-click on the item in there and go to New Group.

Add one of your BOP columns from the left side to the right side. Double-click on the group name to change it to BOP. Then select the other two BOP columns from the left, select your new group on the right, then select add to group. This should put all of your BOP columns in the BOP group.

Now do the same to create a Budget group.

You will now see an item in your Field Parameter area called <yourparametername>(Group) - use this item in your slicer.

Pete