Filtering 2 dates in 2 tables each with a one slicer from date table

[Anonymous]

Hi Team, I have 2 visuals borh are shown monthly "MMM YYYY" (which is derived from date table and is placed on X axis of a line graph)
1. incidents created Vs Incident Resolved.

2. Task created Vs Task Resolved.

I need 1 slicer that would filter both dates (Created date, resolved date) in both visuals. 

Active and inactive relationship concept is used to calculate the created(active) and resolved(inactive).

Can someond help

[Anonymous · Accepted solution]

Hi All,

Thanks you all for your comments with help. What is i did is this.

i used 2 datetables. 

Datetable 1: with active relationship on create date and inactive on resolved date. (cross filtering "Single")

Datetable 2: with active relationship on resolved date and inactive on create date. (cross filtering "Single")

used the slicer from datetable 2.

create a measure DataExists = IF ( OR ( NOT ISEMPTY ( fact_Table1 ), NOT ISEMPTY (fact_Table1 2) ), 1, 0 )

put this measure on filter for the slicer visual and selected 1.

[v-juanli-msft]

Hi @Anonymous 

As Greg_Deckler suggested, a disconnected table would also work.

You could learn this technique from references below:

https://www.blue-granite.com/blog/disconnected-table-power-bi

https://www.fourmoo.com/2019/02/19/do-you-know-how-to-use-multiple-disconnected-slicers-in-power-bi/

As for your ideas about active and inactive relationships among tables,

You could find more detailed guides below to implement it:

https://www.kasperonbi.com/dynamic-data-comparisons-using-disconnected-slicers-treatas-and-inactive-relationships/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

unpivot columns, then create relationships below, 

finally, create a measure and it to the visual.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Second, create a disconnected Date table. Use this as your slicer. Put the logic in your Measure regarding what to display based upon what is selected in the slicer. Hard to be more helpful with information provided.