The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |