To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
This article provideds a workaround https://community.fabric.microsoft.com/t5/Desktop/Parameter-Slicer-shows-incorrect-value/m-p/627670/...
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)
)
This article provideds a workaround https://community.fabric.microsoft.com/t5/Desktop/Parameter-Slicer-shows-incorrect-value/m-p/627670/...
Thanks
Joe
If this post helps, then please Accept it as the solution