Combine two visual with filters applied on those visuals

[Anonymous]

I have a situation where there are two table visuals on two different pages and visual level filters are applied on those two visuals.

Now according to the requirement those two visuals needs to be combined in a single table.

For more information on this please have a look at the attached sample pbix file and please suggest some ideas on how can I combine those two visuals in such a way that all the records from those two visuals should show in a single visual.

[Anonymous]

@jaideepnema - Could you please upload the pbix file over google drive or one drive.

I am not able to replicate the same in matrix.

[jaideepnema]

Hi @Anonymous 
here is the link for the file

https://we.tl/t-aawhTBoN1f

[jaideepnema · Accepted solution]

Hi @Anonymous ,

I would suggest combining the two tables in the below format:

I have created two additional calculated columns 

Week Flag = SWITCH(TRUE(),

Table1[Submission Date] >= TODAY()-14 && Table1[Submission Date]<TODAY()-7,1,

Table1[Submission Date]>=TODAY()-7&&Table1[Submission Date]<=TODAY(),2,BLANK())

Week = SWITCH(Table1[Week Flag],1,"Previous 2 Weeks",2,"Last 7 Days",BLANK())

And then i have created a matrix which gives the result as shown above.

Please accept this as a solution if this answer resolves your query