Forum Discussion
manoj_0911
Kudo Commander
2 years agoHelp Needed: Creating Parameter with Integer, Percentage, and Time Fields in Power BI
Hello Power BI Community, I'm seeking assistance in creating a parameter with specific value types, including integers, percentages, and time durations in HH:MM:SS format. Here's what I aim to ac...
- Anonymous2 years ago
Hi manoj_0911 ,
You can create parameters with specific value types in Power BI by following these steps:
- In the Power BI Power Query, select Manage Parameters.
- In the Manage Parameters window, click on New to create a new parameter.
- Enter a name for the parameter and select the data type. For integers, select Whole Number. For percentages, select Decimal Number and format the parameter as a percentage. For time durations in HH:MM:SS format, select Text.
- Enter the allowed values for the parameter. For integers and percentages, you can enter a static list of values or a minimum and maximum value. For time durations, enter a static list of values in the HH:MM:SS format.
- Click OK to save the parameter.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
2 years agoNot applicable
Hi manoj_0911 ,
You can create parameters with specific value types in Power BI by following these steps:
- In the Power BI Power Query, select Manage Parameters.
- In the Manage Parameters window, click on New to create a new parameter.
- Enter a name for the parameter and select the data type. For integers, select Whole Number. For percentages, select Decimal Number and format the parameter as a percentage. For time durations in HH:MM:SS format, select Text.
- Enter the allowed values for the parameter. For integers and percentages, you can enter a static list of values or a minimum and maximum value. For time durations, enter a static list of values in the HH:MM:SS format.
- Click OK to save the parameter.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.