How to add visual filter on a slicer or filter dropdown?

[Anonymous]

Hi,

I have created a filter drop down on a date like below:

now I want to control the filter values based on user input like the filter values will only come as >=28-03-2019 to 25-03-2019 only. Can I do that?

[judspud]

Hi @Anonymous 

You can either apply a report/page level filter or add another slicer which is then hidden using the selection pane.

Hope this helps

Thanks,

George

[Anonymous]

Hi,

The Page and report level filter is only taking Columns , but not the measure. So in this case I cannot use my measure column : From Date and To Date.

So I think we need to use visual level filter. But whenever i drag and drop any column or measure into it, it does not work for me. So please suggest me what to now?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may add a date column first.Then use a slicer like page1 or use page level filter like page2 in attached sample file.

Date = Table1[date time].[Date]

Regards,