Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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
@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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.