Forum Discussion

Jpss's avatar
Jpss
Icon for Resolver II rankResolver II
4 years ago

Getting user entered value to set target

Hi,

I need to create a target line, where i need value to be supplied by the user. 

So i went with parameters option. The problem i am facing is that the values have to be in Billions.  So i somehow achievedit, and gave it an increment of 10,00,000.

 

 

Well the user wants just a box where they can enter just about any number (i know i can turn off the slider)

 

Which means that i must set the increment of 1. - This is where i am facing the problem

 

 

 

Is there another way to achieve it the same output??  - What user wants is just a box where they can input a value to see a target

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Jpss , Single value box is only given with what if parameter. Where I doubt these values.

     

    But you can use before of after slicer and take the Max or Min value respectively 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Jpss ,

    Please review the following blog and check whether the approach mentioned inside can be used as a workaround or an alternative...

    Applying a measure filter in Power BI

    Revenuess Year :=
CALCULATE (
    [Revenues],
    ALL ( 'Date' ),
    VALUES ( 'Date'[Calendar Year Number] )
)

    Best Regards