Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
2 years ago
Solved

Parameter PBi

Has anyone had the problem of not 'create' button' in on the parameter dialog box I have uninstalled , reintalled, run repair, I have the add slicer check box but no create button, is there a keybo...
Need Help
  • mattiasdesmet's avatar
    mattiasdesmet
    2 years ago

    I had the wrong parameter in mind.

    This issue has been reported before with the Feb 2023 release.

    One workaround would be to change text size in Windows settings Accessibility | Text size . 

     

    Another workaround is to create this manually, as it is a wizard for

    creating a new table like this

    Parameter = GENERATESERIES(0, 20, 0.01)
    and a measures
    Parameter Value = SELECTEDVALUE('Parameter'[Parameter], ".9")
    (with the limits I chose for this parameter and a default value.
    You can then add this in a slicer or reference
mattiasdesmet's avatar
mattiasdesmet
Resolver II
2 years ago

Hi Richard,

where do you encounter this problem? If I go to Edit Query and then in the ribbon to "Manage Parameters", I can create a new one and only press OK / Cancel.

After creating the parameter I can set in PowerBI the value of it in "Transform Data", "Edit parameters".

 

Dicken's avatar
Dicken
Post Prodigy
2 years ago

The problem is I do not have a create button on the parameter dialog box in power bi, 
when you say you can create a parameter in power query via transorm,  create a parameter and yes back to PBi if I got to Transorm Data ; Edit parameters, 
Then what? how to I get them into a measure? 
So say I create a prameter of 10 in Power query , I then want to use it in a measure such as ; 

CALCULATE(SUMX(Test,Test[Unit]),FILTER(ALL(Test[Unit]),Test[Unit] < Parameter)) 
 
Richard.