It is difficult to Ans your question with out looking at the workbook.
To my understanding you would have selected only relevant values in the filters(uncheck this) or your data might have only those ratings in the database. Please check that.
It would be great if you attach your workbook.
Please mark as Answered and helpful if the solution works for you.
Thanks & Regards,
Rather than creating the "Rating Criteria" field as a filter, create a parameter. This way it will show all of the choices all of the time. You can also create an "All" option in the parameter by following this link, https://kb.tableau.com/articles/issue/creating-a-parameter-list-with-an-option-to-filter-by-all-values.
Thanks for your reply! Yes, you are correct. At this moment, at these moment the records only contain ratings of 3.8 and above, though it might change in the future as the data get updated.
However, I still do want to be able to show all possible filter values to the end users for consistency reason. Unfortunately, the workbook contains confidential information that isn't allowed to be shared publicly.
Appreciate your help! I'm relatively quite new with Tableau and not quite familiar with parameters. However, after trying it out and reading some of the threads in the forums I found out that parameters don't support selecting multiple values.
I would need the report to be able to select multiple values from the filter. Would there be any other workaround that enables me to do that?
I have taken this sample data
1) calculation 1: Is your rating criteria calculation
2) then create parameter
3)now write calcualtion 2 as:
4) You can able to see all values in parameter list even though data does not contain values <3.
Data changes as per selection.
Check if it works for you.