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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
brankocareer
Helper I
Helper I

Parameter issue

Hi all,

 

In Power BI, I created a Parameter:

Budget Parameter Salaries = GENERATESERIES(-1000, 1000, 1)

I then placed this variable in a slicer, which allows me to input numbers manually. However, an issue arises:

  • If I enter 1 and press Enter, it displays 1 correctly.

  • If I enter 2 and press Enter, it displays 1 instead.

The pattern is that odd numbers display correctly, while even numbers are shown as (even number - 1).
I am now change the Parameter to:  Budget Parameter Salaries = GENERATESERIES(-100,100, 1). Problem solved, what does this mean?
But I want to keep the range from -1000 to 1000, even bigger, I’m not sure how to resolve this issue, please help me out.

brankocareer_0-1742855641221.png

 


Thank you!

Branko

1 ACCEPTED SOLUTION
v-achippa
Community Support
Community Support

Hi @brankocareer,

 

Thank you for reaching out to Microsoft Fabric Community.

 

The issue occurs because power bi numeric input slicer applies internal optimizations when handling large numeric ranges generated by GENERATESERIES. That is why there are unexpected rounding errors where even numbers display incorrectly.

  • Use the dropdown slicer instead of numeric input slicer, this will pick the exact values instead of applying internal optimizations.
  • Create a custom DAX table, this prevents the slicer optimizations that effect numeric input fields. Use the Value column in the slicer.
    Ex: Budget Parameter Salaries Table = ADDCOLUMNS(GENERATESERIES(-1000, 1000, 1), "Value", [Value])
  • Power BI slicers sometimes handle numbers as floating-point values internally, causing rounding errors. please use the following DAX command if required
    Budget Parameter Salaries = INT(GENERATESERIES(-1000, 1000, 1))

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

View solution in original post

3 REPLIES 3
v-achippa
Community Support
Community Support

Hi @brankocareer,

 

Thank you for reaching out to Microsoft Fabric Community.

 

The issue occurs because power bi numeric input slicer applies internal optimizations when handling large numeric ranges generated by GENERATESERIES. That is why there are unexpected rounding errors where even numbers display incorrectly.

  • Use the dropdown slicer instead of numeric input slicer, this will pick the exact values instead of applying internal optimizations.
  • Create a custom DAX table, this prevents the slicer optimizations that effect numeric input fields. Use the Value column in the slicer.
    Ex: Budget Parameter Salaries Table = ADDCOLUMNS(GENERATESERIES(-1000, 1000, 1), "Value", [Value])
  • Power BI slicers sometimes handle numbers as floating-point values internally, causing rounding errors. please use the following DAX command if required
    Budget Parameter Salaries = INT(GENERATESERIES(-1000, 1000, 1))

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

Pensando na possibilidade de trabalhar com um parametro, com valor unico.  Seria possível capturar o MINIMO e MAXIMO antes de executar a formula? O objetivo seria gerar a tabela com um intervalo controlado, gerada a partir do valor digitado pelo usuario:

 

valor = GENERATESERIES ( MINIMO-5, MAXIMO+5 , 0.01)

 

Ou até mesmo a utilização de um componente visual proprio para a digitação de numeros. Caso exista um componente, você poderia indicar?

Deku
Super User
Super User

Is that the native regular slicer? I can't replicate


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.