Help with Dynamic Constant Line

[sc_1991]

Hi, I am trying to implement a dynamic constant line for one of my scatter plots. 

My issue is that I want the dynamic constant line to take decimal numbers between 0 -700. 

Dynamic Constant Line A= GENERATESERIES(0, 700, 0.01)

Now, the issue is that Power BI creates this table, but when I add it to the Y-axis as a constant line, Power BI does not allow me to enter any value. For example, if I enter 31.25, it rounds it to something like 31.00 or 31.47, but very rarely does it accept the value I input.

When I looked online, they mentioned that it might be related to the length of my array. My array consists of 70,000 rows, and Power BI doesn't handle measures with that many rows well. It samples the data differently, which prevents me from setting the filter as needed.

Can anyone please give me a solution? Thanks

[amitchandak]

@sc_1991 , Hope this was created manually not using the Numeric/whatif parameter. Power BI does sampling after a set of values in case numeric/what if parameter

discussed in past

https://community.fabric.microsoft.com/t5/Issues/What-if-parameters-do-not-work-due-to-1002-sampling...

https://community.fabric.microsoft.com/t5/Desktop/What-If-Parameter-Issue/m-p/313047

[sc_1991]

HI @amitchandak , yes I used whatif while creating the parameter table. It looks like this is still a pending issue and powerBI may bring some new updates in the future to fix it. I did see a workaround mentioned in the link you shared, but that will not work in my case. 

Let's hope the BI team updates this feature quickly. 

Thanks for sending in the link at least I know I am not the only one facing this issue. Much Appreciated.