Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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"
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 🤞
Hi @Kougo
Unfortunately, as far i could investigate, this is not possible. I used a combination of field parameters and bookmarks.
Ah, pity. Thanks for replying so quickly anyway 🙂
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
19 | |
16 | |
16 | |
16 |
User | Count |
---|---|
51 | |
23 | |
20 | |
17 | |
16 |