You will need to ensure that the parameter is being used in all 3 worksheets before using it as a global filter in the dashboard. Stating this should resolve your problem as long as the same parameter is being using in all 3 worksheets. Check it in the 3rd one and see if you have not used the same parameter.
Hope this helps. Additionally, if you can attach a sample packaged workbook than we can try to tackle this issue.
I created a parameter to show the following:
When I add the parameter by 'show parameter control' for each sheet, and choose on eof the choices from above it does nothing. When I use a quick filter from the dimensions on 2 of the sheets, I am able to apply it on the dashboard and it changes 2 of 3. Perhaps I am going about this all wrong. Just to give you some background, below is the following detail:
Sheet 1 - A filled map that is blended with another data source. When I right click on the demension I would like to use as a quick filter, there is no option to use it as a quick filter
Sheet 2 and 3 is not using any blending and that same dimension that I right click on, gives me the option as using it as a quick filter. When I do, I apply it to all worksheets using that data source.
]I created a dashboard and bring in the quick filter from sheet 2 and it will work for sheet 2 and 3 when I change things but doesn't change sheet 1. Someone provided an example for me and the quick filter works exactly as it should but I can't apply it to a new set of sheets and a new dashboard. I know I am rambling but I hope this helps a little more.
I see the problem - parameter will only work with a calculated field. do you have a calculated field that points to the parameter (case/when statement)?
Pass the Parameter for in a calculated filed ""Use that calculated field as a filter under custom value list added the required parameter values to apply for displaying the specific sheet in the dashboard.
As a matter of fact I do. Below is the following parameter:
Name - Source (This is a parameter)
Data Type is = String
The calculated fields I have are the following:
Name - Source Filter (Dimension)
when "All" then [Status]
when "Live" then [Live calls]
when "PRC" then [PRC calls]
Name - Source (This is a dimension - Not the same thing as the parameter)
If[Submitter]= "QA_Importer" THEN "PRC"
Name - Live Calls (Dimension)
IF [Source]= "Live" then [Source] else "Filter out"
Name PRC Calls (Dimension)
IF [Source]= "PRC" then [Source] else "Filter out"
As mentioned before. Someone did this for me and it worked on a specific sheet and dashboard for one of my data sources. I cannot replicate it for another set of sheets and dashboard for another data source. My dashboard has 1 blended sheet (Map) and 2 regular sheets.
I understand what you are saying but I am not quite sure how to do it. I am pretty new to this and some things are easier said than done.
If I want my parameter to be All, Live, and PRC, how do I write that as a calculated field.
Can you attach a sample workbook - this is very easy - its a simple case when statement
your dashboard used more data sources and there is no common values like status, live calls and PRC calls in all sheets. when we add parameter calculation in data blending then we must add same calc in all datasources then only parameter will work. you can check the sheets in fbi dashboard, once the calc applied then select all using sheets option in filter. same calc must done in other sheets using other datasources then must add in filters. your dashboard incomplete status now.
see the calc now.
when "All" then [Status]
when "Live" then [Live Calls]
when "PRC" then [PRC Calls]