Inclusive Page / Visual Filters

Question

Is it possible to configure a report to filter inclusivly ? Scenario to use is:

Table of Incidents

Title

Status

Open Date

Close Date

I would like to create a table of incidents that are either open or closed after 1st December 2020. Ideally this date would be based on date slider. It would be simple to implement an AND, but that is not what I am after.

Any thoughts on how/if this can be achieved ?

pragati11 · Answer

Hi&nbsp;omdavies&nbsp;,
&nbsp;
I don't understand your requirement completly. Can you share some sample data with input and expected output?
&nbsp;
Thanks,
Pragati

omdavies · Answer

Hi, below is an example.&nbsp; The way it is saved shows all Open AND close date of 2021.&nbsp; What I want is open OR close date of 2021.&nbsp; So for example it could show those that are closed but close date in 2021.&nbsp; Does that make sense ?https://remarkabledynamicsltd-my.sharepoint.com/:u:/g/personal/owen_remarkabledynamics_com/EfbDWjvIlvlPkC-dGjS8BS4BpD_8-hSG4ZzBidrcNQCEiA?e=3VXbKx&nbsp;

anonymous · Answer

Hi&nbsp;omdavies&nbsp;,&nbsp;According to my understand, when select 2021 in Close Date ,you want to display&nbsp;one of the open date and close date is 2021. For example,&nbsp;the following data meet the conditions, right?&nbsp;open dateclose date2020/1/12021/1/22021/1/32020/1/42021/1/52021/1/6&nbsp;If so , you need to create a single table for close date and use the following formula:&nbsp;Measure =
IF (
    YEAR ( MAX ( 'Worksheet'[Open Date] ) )
        IN ALLSELECTED ( 'Table'[Close Year] )
            || YEAR ( MAX ( 'Worksheet'[Close Date] ) ) IN ALLSELECTED ( 'Table'[Close Year] ),
    1,
    0
)&nbsp;Then apply the measure to filter pane ,set as "is 1". The final output looks like this:Here is the pbix file.&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;Best Regards,Eyelyn Qin

anonymous · Answer

Hi&nbsp;omdavies&nbsp;,&nbsp;Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.Thank you.&nbsp;Best Regards,Eyelyn Qin

Forum Discussion

Inclusive Page / Visual Filters

4 Replies

Related content

inclusive visual

PERCENTRANK (Inclusive)

Date filters for Visualization

Filters issues in visual objects

Filter on Visual Row Context

open date	close date
2020/1/1	2021/1/2
2021/1/3	2020/1/4
2021/1/5	2021/1/6