Forum Discussion
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 1799 and 1900 is replace by 1899, for example. I have same transformation with some other values.
Can you say why ?
And How I cound resolve this ?
Thanks
Olivier
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
2 Replies
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 thatMaPlage = UNION( GENERATESERIES(0, 99, 1), GENERATESERIES(100, 999, 10), GENERATESERIES(1000, 5999, 100), GENERATESERIES(6000, 10000, 500) )
