Passing Slicer Selection to Query

[elria]

Dea all,

Is there any way to pass the slicer selection in the Query(data selected via SQL connection) or connect the slicer to a parameter?

Thank you in advance,

Elria

[v-lili6-msft]

hi @elria 

It couldn't achieve that "Passing Slicer Selection to Query" in power bi for now.

And you could try power bi parameter, but it is changed in dataset setting.

See more details as below:

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...

https://www.designmind.com/business-intelligence/power-bi-parameters-how-to-use-parameters/

Regards,

Lin

[elria]

hi v-lili6-msft ,

Thank you for your reply. Have you figured out any work aorund for this? I want to give the end user the possibility to change the visuals (calculation output) via slicers, also in Service. I can't ask management eg to edit parameters from desktop.

Could power apps help on this? 

[v-lili6-msft]

hi @elria 

It could not achieve via slicer, slicer is just a visual that used to filter data in report level, and the data from datamodel.

You could use it filter datasource, it likes you filter datasouce, then datasouce filter the datamodel, datamodel changed the slicer will changed too, now slicer also filter datasouce ...... And it goes on forever.

As a workaround, you could import all the data and then combine them into one big datamodel.

Regards,

Lin

[amitchandak]

@elria , I doubt you can pass slicer parameter to query

[jthomson]

I don't think you can feed something back into the query itself like that, but there may be ways to get a similar result to what you're wanting using DAX, it'd depend on what you're actually wanting to do

[parry2k]

@elria Unfortunately it is not possible, I think there is an idea on ideas forum, do vote for it so that this feature becomes available.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[elria]

Hi parry2k ,

Thank you for your reply. Have you figured out any work around for this? How end user can play around with the report then? I need a GUI especially in Service for the report audience.

Thanks,

Elria