Forum Discussion

gokhanatmaca's avatar
gokhanatmaca
Regular Visitor
2 years ago
Solved

PowerBI Desktop - Parameter Issue

Hi, I defined the parameter. When I want to write -50, it automatically becomes -51.

 

  • gokhanatmaca to confirm, it is not issue on your side, it is general behaviour of numeric parameter.
    It will work if you set min value -950, max value 950, increment 1. That is max range. More than that it will not work properly.
    Alternative, keep min -1000, max 1000, but set increment to 2 or to 5, in that case it will work fine.

    Cheers,
    Nemanja

2 Replies

  • Hi gokhanatmaca 

    Can you see a little ! on your visual.

    The slicer can't handle 2000 values so instead it does a representitive sample.

     

    If you change your step to 2 it will be able to have all those represented.

     

    Alternatively change your slicer type to a single select drop down or vertical list. These support more rows than the single slicer

     

    There are also other custom slicers that have search functionality.

  • nandic's avatar
    nandic
    Icon for Resident Rockstar rankResident Rockstar

    gokhanatmaca to confirm, it is not issue on your side, it is general behaviour of numeric parameter.
    It will work if you set min value -950, max value 950, increment 1. That is max range. More than that it will not work properly.
    Alternative, keep min -1000, max 1000, but set increment to 2 or to 5, in that case it will work fine.

    Cheers,
    Nemanja