Forum Discussion
Slicer range is lower than data
The slicer will only show values which exist in the data, so I would guess that the max value in your data is 47.
If you want to ensure a consistent user experience with the same max and min numbers each time, regardless of the data, you could create a new numeric range parameter. Link the Parameter column to your fact table in a one-to-many single direction relationship and your report will only show values within the range selected by the user.
hi All,
I found workaround for the issue and I tested it and it worked for me.
Thank you all for valuable comments!
The slicer will only show values which exist in the data, so I would guess that the max value in your data is 47.
If you want to ensure a consistent user experience with the same max and min numbers each time, regardless of the data, you could create a new numeric range parameter. Link the Parameter column to your fact table in a one-to-many single direction relationship and your report will only show values within the range selected by the user.
You were right actually! I've just realized that table shows cumulative numbers (as i have a few rows giving some numbers per 1 item, hence sums oper 1 item are bigger than 47, but actual number for individual row is max 47 in my data.