Forum Discussion
Power BI Numeric Slicer get low value
Hi TharnageCBT ,
If the number in the slicer is not continuous, you may not be able to get the minimum value of the slicer.
For example,here is a sample data, which is not continuous.
In this case, it does not display the minimum value of the slicer, but the minimum value of the totalpairs column in this range.
Measure = CALCULATE(MIN('Table'[TotalPairs]),ALLSELECTED('Table'[TotalPairs]))An alternative is to create a parameter slicer.
Parameter = GENERATESERIES(10, 800, 1)Create a relationship with totalparis then create mesaure like this.
Parameter Value = CALCULATE(MIN(Parameter[Parameter]),ALLSELECTED(Parameter[Parameter]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Im sorry but this wasnt helpful or a solution. DAX is a built in language of PowerBI, its fine to not know it but you should atleast try to replicate the problem to see why I was asking in the first place.
Community SupportHi TharnageCBT ,
If the number in the slicer is not continuous, you may not be able to get the minimum value of the slicer.
For example,here is a sample data, which is not continuous.
In this case, it does not display the minimum value of the slicer, but the minimum value of the totalpairs column in this range.
Measure = CALCULATE(MIN('Table'[TotalPairs]),ALLSELECTED('Table'[TotalPairs]))An alternative is to create a parameter slicer.
Parameter = GENERATESERIES(10, 800, 1)Create a relationship with totalparis then create mesaure like this.
Parameter Value = CALCULATE(MIN(Parameter[Parameter]),ALLSELECTED(Parameter[Parameter]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.