cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NJ81858
Helper IV
Helper IV

Parameter Help

Hello,

I have created a parameter that allows me to increase a value in my dataset to show potential in the future, along with a slicer that allows me to test different values. It works the way that I want it to, except that I want to be able to input a number into my slicer as a percentage instead of a decimal.

 

For example: 

I type in 0.1 because I want to see what a 0.1% increase does to my data, but instead of showing up as 0.1%, typing in 0.1 yields me a 10% increase.

 

This is my parameter and the way that the data is formatted:

Parameter1.PNG

 

 

Is there a way that I can allow users to type a number into the slicer as a percentage? Thank you!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@NJ81858 , let use type value from 1 to 100, you divide the value by 100 to treat it like %

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@NJ81858 , let use type value from 1 to 100, you divide the value by 100 to treat it like %

@amitchandak that worked thank you! Also, now is there any way to have my slicer default to say 0 instead of being blank? Here is my slicer as is now:

Slicer.PNG

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors