Forum Discussion
Solved
Single value Slicer is refusing values
Hello, In a new blank report, I create a parameter called "MaPlage" from 1 to 10000 by 1, with a Single Slicer MaPlage = GENERATESERIES(1, 10000, 1) But when I tape 1800 it forces into 1...
This article provideds a workaround https://community.fabric.microsoft.com/t5/Desktop/Parameter-Slicer-shows-incorrect-value/m-p/627670/highlight/true#M299871
Thanks
Joe
If this post helps, then please Accept it as the solution
So Slicer is limited probably it doesnt work well over 1200 rows.
I propose a solution : of cause I dont need all 10000 rows steped by 1.
So I changed my serie into that
MaPlage =
UNION(
GENERATESERIES(0, 99, 1),
GENERATESERIES(100, 999, 10),
GENERATESERIES(1000, 5999, 100),
GENERATESERIES(6000, 10000, 500)
)