Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 135 | |
| 102 | |
| 67 | |
| 65 | |
| 56 |