Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to control minimum slicer value?

Hi All,

I have a report where I have two pages. Each has an independent slicer for months.

One needs to go from month 1-6 the second 7-12. It currently reads months from a single column that has months 1-12.

Is there a way to control the range for each slider?

So simply for example a table with a months column:

 

months

1

2

6

9

12

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks but I do not know what a visual filter is. But at this time I decided to use a conditional column to solve the issue. The data as you saw in the simple example is not linear and there may be some overlap from a non-linear sense.

     

     

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Maybe I need to create two new conditional columns one for months 1-6 and the other months 7-12 for example then have each slicer point to the appropiate new column?

     

    Thanks!

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , You can use a page-level or visual filter os slicer on-page.  Can you explain the challenge with an better example

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks but I do not know what a visual filter is. But at this time I decided to use a conditional column to solve the issue. The data as you saw in the simple example is not linear and there may be some overlap from a non-linear sense.