Forum Discussion
Helper IISlicer not showing all values
There has to be something else that's filtering it. Is there anything else on the page? Some other slicer, some other visual? Are there any page level or report level filters?
Community SupportHi cpunnett,
1. As suggested by Anonymous, check if any filter in visual/page/report level. See: Visual filters, page filters, and report filters.
2. Create a calculated column like DistinctCount = DISTINCTCOUNT(<column name>) to check if the column really has 3 distinct values.
3. If there are other visuals in the same report page, check if this slicer is filtered by other visuals. See: Create Complex Interactions Between Visualizations.
4. Please try to run the latest desktop version 2.49.4831.521.
Best Regards,
QiuyunYu
I would also check if there is a relationship in data model that prevent data from displaying in the slicer.
I ran into this issue, when I tried creating new table as a solution mentioned in this post and created a relationship for new table in the data model, then I realized I accidently added a relationship in data model that prevent data from displaying in the slicer.