Forum Discussion
How to Filter data based on New Parameter
Hi PBI Forum,
I have created a new Parameter and used that to create a slicer. Now I would like to use the same slicer to filter days from a different table. That table has number of days column.
So for example: when the user selects a slicer value , the slicer should display all the values which are greater than or equal to the slicer value selected..
Thank you..
Hi,
Thanks for the solution lbendlin offered, and i want to offer some more information for user to refer to.
hello prad001 , you can put the paramater to the visual, then select greater than or equal to , you can refer to the following picture.
Then the slicer will only display the values which are greater than or equal to the value selected.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
When you select slicer value(s) then that is your selection. You cannot then programmatically change the slicer selection in the same column. Consider using a disconnected table for your "other" range, and a measure that reads the slice value(s) and then computes those "other" values. Use the measure as a visual filter.
Hi,
Thanks for the solution lbendlin offered, and i want to offer some more information for user to refer to.
hello prad001 , you can put the paramater to the visual, then select greater than or equal to , you can refer to the following picture.
Then the slicer will only display the values which are greater than or equal to the value selected.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
