Do applying Parameters using the "New Parameter" button improve performance?

[Anonymous]

Pricing reports are huge. I am breaking up the report by different channels (eliminate eCommerce). 

I'm doing that in the filter pane and thought that eliminating using a Parameter could improve the performance. I am assuming that the Parameter Button inserts code directly into the base query to eliminate rows. 

Let me know. Thank you!

[PaulDBrown · Accepted solution]

@Anonymous 

If you are forfeiting data altogether, you can filter out columns and/or rows directly in Power Query (even better if you can do it at the source itself) and these will not then be loaded into the model.

The "New Parameter" function in the ribbon is to create a new table with values which you can then use in "what if..." type calculations..

[Anonymous]

I am not forfieting data. FYI, I'm building a reporting "cube" and building reports along the way to run into measures to build for the PBI inexperienced team members. I need to know the best way to filter data. 

From what you said the Parameter would slow it down. 

If a large report is blessed before I leave the client I'll use PowerQuery to eliminate some data and document it for the team. That idea makes me sick!