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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Jpss
Resolver II
Resolver II

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.

pic 6.png

 

 

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

 

pic 7.png

 

 

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

2 REPLIES 2
Anonymous
Not applicable

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] )
)

yingyinr_0-1649321177967.png

Best Regards

amitchandak
Super User
Super User

@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 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors