parameters SQL / buttons

[Anonymous]

Hi

i have a sql statement containing paramater.

@placed=<3

How can I integrate this into PowerBI so a user can select different parameters? I.e. alter the =<3

User Screen would like :

When this number (button) is clicked, it would run the sql query (direct query). That would be enterted in the parameters query and return the specific counts. I can do this in Excel but struggling in PowerBI.

Appreciate the guidance

Thanks

Anthony

[Anonymous · Accepted solution]

@Anonymous 
You can create a what if parameter. 

Use what-if parameters to visualize variables - Power BI | Microsoft Docs

Then add add the parameter to your measures as an additional filter, for example.

Measure = CALCULATE(SUM([Value]),FILTER(Table,[placed]<=Selectedvalue((Parameter[Parameter]))))

You can selected any number as the filter conditional.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , see if Dynamic M paaremeter can help

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

For button you can use slicer with horizontal orientation