Dynamic Field in Slicer based on Field Parameter selection

[AndreasGjNi]

Hi PBI Community

I have been stuck for a while on trying to build upon my Field Parameter into a slicer. 

I have a Field Parameter that switches between four columns (Min Quantity, Max Quantity, Avg Quantity, Confirmed Quantity).

I need a Slicer / Filter that is populated by the field (4 columns, Min Price, Max Price, Avg Price, Confirmed Price), based on the selection in the field parameter. 

So e.g, if i were to select "Min Quantity" in my Field Parameter, the slicer would contain the "Min Price" column and so forth. 

I have looked into combining IF() and SWITCH(), but the Slicer won't accept the measures i have created as valid. 

All help is appreciated.

Kind regards,
Andreas

[KWYew]

Hi guys,
I had the same problem, and found a solution online.
Check out this video:
https://youtu.be/nWgPynP9XDM?t=169

In case the link doesn't work, below some brief description:

1) Duplicate the field parameter slicer

2) Select the duplicated slicer, from the visualisation panel "Field" Section, drop down and select "Show values of selected field"

[Anonymous]

Hi Andreas,
I've come across your post as I'm trying to do exactly the same thing...!  If you figured it out in the end, please could you share what you did?  Thanks 🤞 

[AndreasGjNi]

Hi @Anonymous 

Unfortunately, as far i could investigate, this is not possible. I used a combination of field parameters and bookmarks. 

[Anonymous]

Ah, pity.  Thanks for replying so quickly anyway 🙂

[AndreasGjNi]

Hi @v-cazheng-msft 

Yes, this is precisely what i'm trying to solve.

BR,
Andreas

[v-cazheng-msft]

Hi @AndreasGjNi,

You mean you want the items in Slicers or Filters pane will dynamically change according to the selection of your Field parameter?

Best Regards,    

Community Support Team _ Caiyun