Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Slicer Based on Filters

Hey,   I didn't find an iteration of this that had been answered before. I'm trying to find a way to create a dynamic slicer which determines what options to present the user based on other selecti...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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!

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

As you say you cannot create a slicer with a measure, however you can use a measure to filter out a report a page or a visual, in this case I believe that you can use one of two options:

 

  • Place your measure on the page / report filter and then the slicer will be filtered out
  • Create an input page that uses slicer to make the selection and then sync the slicers to other pages with this ones hidden.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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!

    • MFelix's avatar
      MFelix
      Super User
      8 years ago
      Hi Anonymous,

      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
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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!