Parameterized MDX query for PowerBI reports

[techiebee]

Hi All,

I need to put month and year slicer in my PowerBI report and those values should be passed as parameters to the MDX query which pulls data from tabular model into report. Multiple selection can be there in month and year values.

Could anyone please share ideas with me in implementing this?

[v-caliao-msft · Accepted solution]

Hi @techiebee,

Multiple selection can be there in month and year values.

Currently, Multi-Slelect parameter is not supported.

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao

[parry2k]

Hi there,

Here are some interesting links and I'm surely it will get you going.

https://blog.crossjoin.co.uk/2016/12/11/passing-parameters-to-sql-queries-with-value-nativequery-in-...

http://biinsight.com/power-bi-desktop-query-parameters-part-1/

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

Hope it is helpful.

Thanks,

P