Forum Discussion
Dynamic Slicer Based on Filters
Thanks for your help Felix!
I couldn't get that solution to work however it helped me think of another solution. I created a table with the options available to the user. The table had 2 columns, one column for the title I wanted the user to see as they selected an option, the second column for the variable I wanted to pass into my equations. Then I went to my equation and referenced the value column of the aforementioned table and said to add that value to my equation.
Thanks again!
Thank you Felix!
I'll actually need the dynamic slicer to inform a measure that reflects across different tables and graphs so a visual filter won't work in this case. I'll keep that solution in mind for the future though!
Don't know how.is the measure you use to identify the months selected but that measure can be placed in report filter or page filter. And filter out the slicers on the page.
So.assuming that your measure returns 1 for days.to be.consider and 0 for other days.if you place that measure on report level.filters and select only 1 it will filter.out.your.slicer.dinamically.
Regards,
MFelix
Thanks for your help Felix!
I couldn't get that solution to work however it helped me think of another solution. I created a table with the options available to the user. The table had 2 columns, one column for the title I wanted the user to see as they selected an option, the second column for the variable I wanted to pass into my equations. Then I went to my equation and referenced the value column of the aforementioned table and said to add that value to my equation.
Thanks again!