single value slicer
1 TopicGenerateseries is not working with a parameter and single value slicer
I am trying to create a single value slicer I have created a parameter "Target Parameter" and a table "Target" My parameter is "Target Parameter = GENERATESERIES(MIN(Target[Target]),MAX(Target[Target]))" (I have also tried adding the increment of 1 with the same result) the Target Table has 1 column with numbers from 0 to 1048576 generated from a linked excel file. Data type is Decimal Number but I have tried Whole and Fixed as well. When I look at the tables, I don't see any error in the sequenced numbers. When I enter a value such as 100000 into the associated slicer, the number in the slicer automatically changes to 99516 When I enter 2 it is automatically changed to 1 When I enter 1048570 is automatically changed to 1048576 Every number I have tried is changed to a different value except the largest number 1048576 Is there anyway to get it to accept and use the value entered? I intend to use the entered number in other calclations.1.4KViews0likes1Comment