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

[LT4RFF]

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?

Client	2025-01-13	2025-01-20
Beano	50,258.00	40,235.00	-10,023.00
Senedd	300,548.00	256,326.23	-44,221.77
Flip Flop	30,258.00	45,825.63	15,567.63
Backflip	895,287.59	548,259.33	-347,028.26
Speakbox	48,528.88	15,475.52	-33,053.36

[Irwan · Accepted solution]

hello @LT4RFF 

to achieve this, you can disable their interactions.

here is when the selection made in both slicer.

Hope this will help.

Thank you.