Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Zynka
Regular Visitor

Parameter Slicer shows incorrect value

Hello everybody!

 

Im haveing a problem with a parameterbased slicer.

 

The parameter looks like this: Parameter = 

GENERATESERIES (0; 10000; 5)
 
When i write for exapel 2575 in the slicer it will autocorrect to 2578 or 2573.
Anyone have a clue how to solve this?
 
kind regards//
Jesper
1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Zynka 

 I can reproduce your problem, as searched, it is said "it's because of the range being too big and the numbers are being sampled" accoding to the following link.

What if parameter help - input changes by itself after hitting enter

 

As a workround, you could click on the "down" arrow on the top-right of slicer and select "between" or "list" as below

8.png

or you could change the "increment" from 1 to 5 as my first picture.

5.png

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-juanli-msft
Community Support
Community Support

Hi @Zynka 

 I can reproduce your problem, as searched, it is said "it's because of the range being too big and the numbers are being sampled" accoding to the following link.

What if parameter help - input changes by itself after hitting enter

 

As a workround, you could click on the "down" arrow on the top-right of slicer and select "between" or "list" as below

8.png

or you could change the "increment" from 1 to 5 as my first picture.

5.png

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft
Community Support
Community Support

Hi @Zynka 

As tested with last version 2.66.5376.1681 64-bit (February 2019), it works correctly on my side.

5.png

 

Could you show an screenshot or an simple pbix how you create and use the parameter?

 

Best Regards

Maggie

Hi!

 

Ofcourse, Im having the same problem with several slicers

 

 

Skärmklipp.PNG

The value I try to put in is 2575 but its autocorrecting to 2577, as you can see this is a new project so it dosnt depend on my actuall report, maybe som settings I dont know off?

 

Thankfull for your time//

Jesper @ Zynka

az38
Community Champion
Community Champion

maybe its because of the minimal autogenerated value is 3, not 0 or 1?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Zynka
Regular Visitor

Thanks for your answer, dont know if I understand correctly but I can still get the value 0 or 10 000 both by typing or move the controller. It appers like it somewhere above 1 500 begins to count 3, 8, 13, 18 etc.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.