Forum Discussion
Using a slicer to select a variable rather than filtering a single variable
Hi,
I have a dataset which I unpivoted so I can select a single early learning goal from a list and the page will update. The advantage of this is that I don't have to duplicate the same page 12 times.
But due to some other analysis I wish to do, the data has to remain pivoted. Instead of importing the data twice and having two different formats, is it possible to set up a slicer so I can select data from different columns? Is the switch function useful for this?
TIA
Hi, I found a great video on this subject: https://www.youtube.com/watch?v=-nqEv2YXLsU
From watching this, I didn't want to select the columns themselves, but the calculated measures so the charts will update. Thanks 🙂
4 Replies
Looks like you are describing the functionality of Field Parameters ?
Hi Scubadiver007,
Thank you for reaching out to Microsoft Fabric Community Forum.In your case, since you're working with pivoted data and want to dynamically switch between different Early Learning Goal columns without duplicating the dataset, you can use Field Parameters in Power BI. This feature allows you to create a slicer that lets users select which column to display in your visuals—ideal for your scenario.
If Field Parameters don’t work as expected or you run into any issues, please share a sample of your dataset (with all sensitive information removed) along with the expected result. This will help us understand your structure and provide a more accurate solution.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara ReddyHi, thanks for the responses, and will investigate!
Hi, I found a great video on this subject: https://www.youtube.com/watch?v=-nqEv2YXLsU
From watching this, I didn't want to select the columns themselves, but the calculated measures so the charts will update. Thanks 🙂
