Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Value Slicer with one entry

  • 1.  Value Slicer with one entry

    Bronze Contributor
    Posted 30 days ago
    Edited by Chong SM 30 days ago
    Hi,

    I am looking for a single value slicer (numeric), i.e. u just need to enter one value instead of having to enter 2 values to form a range because the other value is the same. Since I can't find such this slicer in the marketplace, I thought maybe some Power BI experts here can help.

    Thanks!

    ------------------------------
    Chong SM
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Value Slicer with one entry

    Top Contributor
    Posted 30 days ago
    Hi Chong !

    The available [Slicer] which comes with PBI Desktop default set of visuals has following options;

    [List], [Drop down], [Less Than or Equal To] & [Greater Than or Equal To]

    Both [Less Than or Equal To] & [Greater Than or Equal To] provide single numeric input but than they assume the 2 value which will not work in your case.

    Please try [What-If] parameter which will allow you create a [Slicer] with range [Min - Max] but you can choose single input value.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Value Slicer with one entry

    Bronze Contributor
    Posted 27 days ago
    Hi Hasham,

    Thanks for sharing. Much appreciated.

    Regards.

    ------------------------------
    Chong SM
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: Value Slicer with one entry

    Bronze Contributor
    Posted 27 days ago
    Hi,

    One more question regarding what-if parameter. Let's say I set a minimum of 0 and maximum of 2000, with an increment of 1. I noticed at times when I entered a number into the box it would automatically decrease by 1. E.g. If I enter 1577, the value becomes 1576. But if I enter 1578, the number showing on the box is correct. This looks like a bug to me, not sure if there is any workaround or if MS is aware of the issue?

    Thanks!



    ------------------------------
    Chong SM
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Value Slicer with one entry

    Posted 27 days ago
    The slicer has a limit on the number of values available which is approx. 1000. If you have above 1000 values it will show "a representative sample". It's not a bug, it's a feature.

    ------------------------------
    Mads Steenstrup Hannibal
    Senior Advisor
    ------------------------------

    Conference-PBI_200x200


  • 6.  RE: Value Slicer with one entry

    Bronze Contributor
    Posted 27 days ago
    Thank you for sharing! :-)

    ------------------------------
    Chong SM
    ------------------------------

    Conference-PBI_200x200