Can we create a slicer based on the List Parameter in the Desktop

[KR300]

Hi I have created a list Parameter to change " datasource '  like below

VersionParameter

Version.v1.1

Version.v1.2

Version.v1.3

..

..

Version.v1.20

Can we convert this Parameter ( Which is created in Power Query )  as a slicer in Power BI desktop. So that we can use simply slicer to change datasource to selected version value in the path instead of going to Home->Queries->Transform Data->Edit Parameters  then change the Parameter. 

It would be easy to change the values for the datasource in the dashboard at the PBI service level also right? -- Is it possible?

I think it is not possible to pass slicer value as a parameter value in the source path, right?

Pls Help me out

[Anonymous · Accepted solution]

Hi,

Thanks for the solution danextian  offered, and i want to offer some more information for user to refer to.

hello @KR300 , based on your description, if you want to use the paramater dynamically in power bi desktop, you need to use the dynamic paramater by using direct query mode, you can refer  to the following link about the dynamic paramater.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Unlock the power of dynamic parameter binding for ... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @KR300 

Slicer selections are not passed on to the query editor. The query editor affects the semantic model but it is not the other way around. If you want the data to be  sliced by ther version numbers, you will insteadneed to load all the versions together with the version numbers.

[KR300]

If you want the data to be sliced by ther version numbers, you will instead need to load all the versions together with the version numbers. - didn't get this>

[danextian]

What I meant is that you need to load the entire dataset, ensuring it includes a column that specifies the versions. This will allow you to slice the visualization based on those versions.