Selecting two data sources, creating a table containing the independent data and then comparing

Apologies, I have seen a similar thread but my requested is a bit more complicated.

I have two data sources

• 2025-01-13
• 2025-01-20

They contain data from two different weeks.

In my dashboard I am able to select the source data (2025-01-13 or 2025-01-20) and it will populate depending on which source I select.

What I would like to do in my dashboard

• Have two dropdown boxes which will enable me to pick two data sources
• Then create a table which will compare the data and identify improvements or detriorations using conditional formatting.

Problem 1. When I select one source the other changes

I cannot independently pick two separate data sources

Once I can do that I would like to see something like this

• I have two sets of data appearing 2025-01-13 and 2025-01-20
• I have then deducted 2025-01-13 from 2025-01-20 to give me the difference between the two sets
• I have then created a conditional format to show me anything that decreased in the week is green (good) and anything that increased in the week is red (bad)

Those are my two questions

• How do I create two dropdown boxes that are independent from one another?
• How do I create a table from the two data sets from the two dropdown boxes?