Forum Discussion
Helper IIFilter Slicer based upon input parameter or page level report filter
I have requirement to filter out slicer based upon the input parameter, where input parameter is part of your fact & dimention table.
Can somebody help me to setup filtering based on input values.
6 Replies
- amitchandak
Super User
Mohd_Naim ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
But if you are trying to create a table or column based on slicer value that is not possible
Appreciate your Kudos.
Mohd_Naimamitchandak I have a Dimention table based slicer which has all unique records associsted with Fact table, where i want filter slicer value by passing parameter value,
like example table ,
StudID,Subject
1, 4
1, 2
2, 1
3, 2
I want slicer will show only for StudID 1 when user pass 1 or 2 for 2.
PaulDBrownCommunity Champion
"I want slicer will show only for StudID 1 when user pass 1 or 2 for 2. "
Sorry, I'm not following what you are trying to achieve based on the data you have posted. Can you explain further?
v-zhenbw-msftCommunity Support
Hi Mohd_Naim ,
Do you want to put a field in Filters on this page, then control the slicer like this?
You can use this method to control the display of the fields on the Slicer.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
