I'm not 100% that we can do what you want by using the Page Shelf. Pages, are different than Filters, in the sense that they do not change the Level of Detail (in regards to what dimensions that are in your viz). They do however change what is being displayed, or as Jonathan Drummey puts it, the displayLoD
This is why your Sort Order doesn't change, and why you still show countries in your Viz, even if their values are NULL within the Page being shown.
Is there any particular reason you are using the Page Shelf? Or could a Single Value Dropdown work for you? The latter resolves both issues you are currently facing.
If I understand correctly, you suggest to move the pill to the "Filters" shelf. I tried it, and it yields better results. But, the problem is that with the real data set that I'm exploring I have a very long list of categories and it is much nicer to user the arrows to skim through the different cats.
Furthermore, in the big data set (which I cannot share), even if the "Cat" pill is in the "Filters" shelf, I can still find "Cat"s that don't have any counts but they still show up (with no hight) when I choose that category.
1 of 1 people found this helpful
To your first point....
What about using a Single Value Slider? It resembles what the Page Shelf slider looks like
Onto you second point.
Do you have "Show Empty Columns" Or "Show Empty Rows" turned on?
This could be causing them to show up, even if they don't have a value.
Also, if you do have a Value in your Dataset, even if 0, it could be still showing up. So to eliminate that issue, you can drag your [Count] field onto the Filter Shelf and limit it to not show 0 Values.
Hope this helps.
Here's what I did:
1) Removed the "Cat" pill from the filters
2) Set a filter on the counter >=1
3) Added the "Cat" pill to the "Filters" shelf and set it to "Single Value (Slider)".
Now, it seems to behave (more or less) as I expected.
What is a recommended read in order to understand the difference between "Pages" and "Filters" shelves?
Great! I'm glad it is working for you (more of less )
The online help guides are a great place to start on learning about various aspects of Tableau
If this question has been resolved, would you mind marking my response as correct? This will close out the thread, and it helps other members who are searching for answers to similar questions.