Forum Discussion
3508026
Helper II
Helper IISlicer for filtering several columns
Hello, I need to create slicer for filtering the data that are in different columns: - Slicer for filtering the view: The optiona are in different columns. - Slicer for filtering the metric: The o...
Hi 3508026
Yes, you can use field parameters. Although, not really ideal but it's possible.
- On the ribbon bar, under MODELING select 'New Parameter' and then select 'Fields'
- Create a name for your parameter, for example, 'View' and add all the fields you want to be part of that parameter.
- Repeat for as many different parameters you may need or have. Then, if you don't have 'View Hidden' on your model enabled already, for each of those new parameters, right click the table, and click 'View Hidden'
- Finally, drop the 'Fields' column to any of your visual(s).
I have attached a sample pbix file for you:
- On the ribbon bar, under MODELING select 'New Parameter' and then select 'Fields'
3508026Helper II
Helper IIHi hnguy71
Thank you. The structure you suggested would be ideal, but my dataset is already very large, over 17 million rows. Is there another option? I’ve never used Parameters before, so I’m not sure if they could be the right solution.
hnguy71
Super User
Super UserHi 3508026
Yes, you can use field parameters. Although, not really ideal but it's possible.
- On the ribbon bar, under MODELING select 'New Parameter' and then select 'Fields'
- Create a name for your parameter, for example, 'View' and add all the fields you want to be part of that parameter.
- Repeat for as many different parameters you may need or have. Then, if you don't have 'View Hidden' on your model enabled already, for each of those new parameters, right click the table, and click 'View Hidden'
- Finally, drop the 'Fields' column to any of your visual(s).
I have attached a sample pbix file for you: