Forum Discussion

jgray72's avatar
jgray72
Icon for Helper II rankHelper II
6 years ago

Parameters in Report Builder (DAX query copied from Performance Analyzer)

Hi - I'm building my first report in Power BI Report Builder and followed instructions to copy my query from Performance Analyzer.  The query works as expected and it' s a huge time saver to copy it ...
Need Help
jgray72's avatar
jgray72
Icon for Helper II rankHelper II
6 years ago

I've also tried playing around with the @, but it won't work either.

 

 

JG

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

So one way to do this is to add a filter to your visual in Power BI for the Brand and Season. This will add an "_DS0FilterXXX" variable to your query and inject it into the appropriate place in the SUMMARIZECOLUMNS expression.

 

So if you set a Brand filter of "XYZ" and a season filter of "Winter" the you would just need to find these two strings in the query you copy from the Performance Analyzer and then replace the hard coded values with a reference to @Brand and @Season (or you could use the Parameters!Brand.Value string expression approach)