Forum Discussion

AndreasGjNi's avatar
AndreasGjNi
Frequent Visitor
3 years ago

Dynamic Field in Slicer based on Field Parameter selection

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

DAX
Dynamic
field parameter
Slicer

6 Replies

  • KWYew's avatar
    KWYew
    Frequent Visitor
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      AndreasGjNi
      Frequent Visitor
      3 years ago

      Hi Anonymous 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Ah, pity.  Thanks for replying so quickly anyway 🙂

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    3 years ago

    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