How to control minimum slicer value?

[Anonymous]

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!

[amitchandak]

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

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

Use a visual level filter on each visual.

[Anonymous]

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!