Are you able to use a parameter + calculated field instead of a quick filter?
I haven't tried to use parameter because I need option that can select both of State 1 and State 2. And from my understanding this kind of function not available if we use parameter.
1 of 1 people found this helpful
Yes, that's correct, no multi select in a parameter. Considering the problem my simplistic approach would be to group Unknown and Null into a separate 'Unknown' group and display that value in the filter. This is because isn't State 1 or State 2 hence could be confusing to the user, especially if they choose to view the data.
Generally in situations like this I would put a note in the filter title asking them not to deselect Unknown if they shouldn't be doing so.
Perhaps this solution is less elegant than you would like but:
- It's simple
- It's clear to the dashboard user what is happening
I don't know if this solution will be a straight forward solution but by my intrepretation of your issue i think this should work.
Create a new calc field for your measure column and use a parameter instead of quick filter if possible and assign values State1 and State2
IF [Parameter] = 'State1' THEN
IF [State] = 'State1' OR [State] = NULL OR [State] = 'Unknown' THEN [Measure Value]
IF [State] = 'State2' OR [State] = NULL OR [State] = 'Unknown' THEN [Measure Vlaue]
As you have mentioned in your comment that you would want users to select both the values as well then what is the inteded behavious [State1]+[State2]+NULL+Unknown or [State1]+[State2]+NULL+Unknown+NULL+Unknown?
If you are ok with showing 3 values to your users in parameter then both the values can also be selected.
Incluse another value in your paramter State1+State2
and in the above calc instead of ELSE use ELSEIF
[Parameter] = 'State1+State2' THEN [Measure Value]