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 selections the user makes. I can determine what month counts to show the user via measures, however I cannot put measures into a slicer. Similarly I don't think I can use a custom column because I need the slicer logic to determine what dates to show the user based on filtering selections the user makes after the model is loaded in and complete.

 

Is there a way to dynamically change a slicer based on logical if-then statements?

 

For Ex:

Available Months at Start: All months 2017-2018

User Inputs Filter, Available Months Now: May (first half), June, July, August (last half)

Logic: For each month that has all data, show that month as an option in the slicer

Slicer: June, July

 

Thanks!

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!

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper 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
        Icon for Super User rankSuper 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