Forum Discussion
Negative values in slicer
I did some test, but just as PhilipTreacy said that it works very well.
Maybe you can try to change the style of the slicer to List or Tile to see if there are negative values.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.You stated that the minimum value is 1000, but in the subsequent post your image shows the min value in the column as 1. It obviously can't be both.
The slicer gets its data from the column so if it's allowing negative numbers, there must be negative numbers in the column.
Is your slicer using data from the TotalDurationMin column?
Please supply your data/file so we can check.
Regards
Phil
As you can see, I ordered the data is ascending order and the minimum value is 1, still the slicer accepts a negative input. Is there any way to restrain the value?
You stated that the minimum value is 1000, but in the subsequent post your image shows the min value in the column as 1. It obviously can't be both.
The slicer gets its data from the column so if it's allowing negative numbers, there must be negative numbers in the column.
Is your slicer using data from the TotalDurationMin column?
Please supply your data/file so we can check.
Regards
Phil