I think you're going to have to explain your situation a bit more, or upload a mockup.

Parameters don't work like filters because they are not dimensions.  Parameters hold a single global value and dimensions have a list of values that you filter on.

Do you have some sort of calculated field on the filter shelf that you need to remove ?

Hi Nwador,

As "Chris Mcclellan" as mentioned  "Parameters don't work like filters because they are not dimensions.  Parameters hold a single global value and dimensions have a list of values that you filter on" rightly said.

parameter work with a Calculated Field so, you need to use this calculated field where you want your parameter to work. else you need to duplicate the parameter as well as calculated field and use is visly.

Please don’t forget to mark Helpful and CORRECT if it solves your problem.

Regards

Bhujang

Stanley - Parameters are associated with one of the dimension using calculated field. So put that calculated field in filter shelf only in the sheet you need. so it will work for only that sheet.

-Nikunj

Hi Stanley:

In your filters, make sure you are applying the filtered measure only to the sheets you want:

I've attached a sample that works with REGION. Good luck! --Michael

To answer the easy one - to duplicate a parameter, just right-click on the parameter in the list in the side bar on the left when you're in a worksheet, and select "duplicate" from the pop up list.

Hi - are you still stuck at the parameter and not got answer? share your workbook with sample data so that I can help you

-Nikunj

Hi Stanley

I think you're going to need to upload a sample workbook to show what the problem is because I don't understand (and I suspect I'm not alone) exactly what the issue is.

Some of what I've written below may help but if not, if you can attach the workbook, suitably anonymised, or mock up another one showing the issue, it may help us understand the problem.

Apologies if some/all of this is obvious to you but I don't know how much you know so I'm keeping it simple for now:

When you set up a parameter, that in itself doesn't drive anything.  You now have a parameter which you can put on your dashboard and a user can select different values but all that will happen is that the parameter value will change.

To use that parameter, you need to have one or more calculated fields which reference(s) the parameter which you then use, whether as a value in a chart or table, or as a filter, or in some other way.  Let's say your field is called FIELD_P.

When a user changes a parameter value, that is a global thing and you cannot stop the changed parameter value from changing any calculated fields which depend on it.  So to make the parameter affect only the sheets you want it to affect, you need to make sure you only use your calculated field (FIELD_P) on those sheets. 

If you have other sheets that you don't want to change at all, then you will need to use a different field, that does not reference the parameter, for those sheets.

If you have other sheets that you want to change, but you want to be able to set the parameter differently for those sheets, then you'll need to have another parameter, and other calculated fields which reference that other parameter, for those sheets.

So maybe you have, for CHART1, a parameter PARAMETER1, and calculated field FIELD_P1 and then for TABLE2, a parameter PARAMETER2 and calculated field FIELD_P2.

If none of this helps or makes sense, then please try to attach a workbook so we can understand exactly what you're having problems with.

Thanks

Anna

Well spoken, Anna Cheetham !