Forum Discussion

brankocareer's avatar
brankocareer
Helper I
1 year ago
Solved

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. How...
  • v-achippa's avatar
    1 year ago

    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