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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Dicken
Helper IV
Helper IV

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 

1 ACCEPTED SOLUTION
mattiasdesmet
Resolver II
Resolver II

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

View solution in original post

5 REPLIES 5
mattiasdesmet
Resolver II
Resolver II

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

Just to add going down to 100% worked.

Thanks for the help, and at least I know it's not just me.

RD

mattiasdesmet
Resolver II
Resolver II

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".

 

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. 
 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Users online (2,367)