Forum Discussion

jomikk's avatar
jomikk
Helper I
9 years ago
Solved

Dynamically change query with button

Hi, I am querying to a SSAS database with MDX query. I was wondering if it is possible to add a +/- button to change the query dynamically in the report? So if I press -1 then it changes the query wi...
Need Help
jomikk's avatar
jomikk
Helper I
9 years ago

Thanks! I am importing, not connecting live. The solutions linked seem like it is only possible to do it in the query editor? Can you add a button on the report page as well?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jomikk,

You can add slicers in the report page and use slicers to filter your visuals to show yesterday data.  

Another option is to add parameter using "Manage Parameters" button in Query Editor , then you are able to enter parameter value by clicking  “Edit Queries” ->“Edit Parameters” as described in the following blogs.

http://biinsight.com/power-bi-desktop-query-parameters-part-1/
http://biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters/

Regards,
Lydia