Decimal Number fields let you enter or select fractions of a number. This feature lets your slicer cleanly align to whole numbers. Snap to whole numbers with the numeric range slicerĪ numeric range slicer snaps to whole numbers if the data type of the underlying field is Whole Number. Now, only items with a LineTotal greater than or equal to 4902.99 display in the visuals on the report page. You can then adjust the lower value, as seen in the following image. Lastly, if you select Greater than or equal to, then the right (higher value) slider bar handle disappears. In the following image, we set the slider bar maximum to 5928.19. When you select Less than or equal to, the left (lower value) handle of the slider bar disappears, and you can adjust only the upper-bound limit of the slider bar. In the following image, the report page filters for LineTotal values that range between 2500.00. This option is convenient when you want to slice on specific numbers. You can also use the slider and select either box to type in the values we want. Sometimes the granularity of moving the slicer bar makes it difficult to land exactly on that number. You can use the slider to select numeric values that fall between the numbers. When you select Between from the menu, a slider appears. If you don't see the down arrow, open the Format pane for the slicer and set the Slicer header to On.įor the numeric range, you can select from the following three options:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |