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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

The parameter have a bug

When the parameter range is greater than 10000, or even more values, the input value and the displayed value will be inconsistent. For example, when I input 9820, 9815 will be displayed, which will lead to inaccurate calculation results. I hope the new software can improve this problem.

Status: Investigating

Hi @shyke ,

 

What version of Power BI Desktop are you using and what type of parameters are you creating? What is the usage scenario?
Are you able to provide detailed steps for replication?
I created a query parameter on Version: 2.110.1085.0 64-bit (October 2022) to test it, but I don't seem to have a similar experience as you.

 

Best Regards,
Community Support Team _ Caitlyn

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @shyke ,

 

What version of Power BI Desktop are you using and what type of parameters are you creating? What is the usage scenario?
Are you able to provide detailed steps for replication?
I created a query parameter on Version: 2.110.1085.0 64-bit (October 2022) to test it, but I don't seem to have a similar experience as you.

 

Best Regards,
Community Support Team _ Caitlyn

 

shyke
Frequent Visitor

The scenario where I use parameters is mainly used for more flexible big data calculation.

1.My software version is 2.110.1161.0 64 bit (October 2022)

shyke_0-1668501428438.png

 

  1. When I input 3500 in the parameter, the displayed 3497 results in the calculation formula 3497+123=3620. This result is not what I want.

In fact, what I need is 3500+123=3623, which is the correct result

shyke_1-1668501428454.png

3.You can view the calculation results caused by incorrect parameters through the following link.

https://app.powerbi.com/view?r=eyJrIjoiMWJhOTU3YTUtYzE1My00ZGUwLWEwZGQtYjlhYzM3NDY0MGJhIiwidCI6IjY2Y...

 

 

shyke
Frequent Visitor

This is my calculation formula and operation process

2022-11-15_165330.png

shyke
Frequent Visitor

The parameter range I set is from 1to 10,000,and the increment is 1.

shyke_0-1668503363326.png

 

shyke
Frequent Visitor

@V-凯特琳-MSTF The above is my testing process.

Below is a link to the test report I posted.

Microsoft Power BI