Forum Discussion
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 keyboad shortcut to bypass the need.
Richard
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 measuresParameter 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
5 Replies
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 measuresParameter 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 referenceHi 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".
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.
