Comparison Between Two Variables

[MacroHardOnFire]

I'm working on a report where I need to display comparisons of two binary categories. In particular, I need to show both raw numbers and gaps between them. The raw numbers are easy, and the gap isn't difficult if I know what the two categories are. I want the display percentage gaps between groups A and B like below, where positive numbers indicate that the gap between A and B favors A, and negative numbers the opposite. It also changes colors based on if the number is positive or negative.

Here's the challenge: I want A and B to be variables. Specifically, I want them to be variable filters that the user can choose and change at will. This is all on a single dataset, so it's easy to filter these categories individually. My challenge is applying these two different filters to a single visualization. For example, comparing in-state vs out-of-state, where more in-state for a given year is positive, and more out-of-state for a given year is negative. I want this to be possible across a wide range of categories that the user can choose.

[v-rzhou-msft]

Hi @MacroHardOnFire ,

Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MacroHardOnFire]

I want to make something like the below screenshots. The sample data will be in the following post.

[MacroHardOnFire]

ID	Year	Name	Gender	Acquired Powers	Beyond Cameo
1	2000	Aquaman	Male	Birth	Yes
2	2000	Atom	Male	None	Yes
3	2000	Atom-Smasher	Male	Later	Yes
4	2000	Aztek	Male	None	No
5	2000	B'wana Beast	Male	Later	Yes
6	2000	Batman	Male	None	Yes
7	2000	Black Canary	Female	Birth	Yes
8	2000	Blue Devil	Male	Later	No
9	2000	Booster Gold	Male	None	No
10	2000	Captain Atom	Male	Later	Yes
11	2000	Captain Marvel	Male	Later	Yes
12	2000	Commander Steel	Male	None	No
13	2000	Creeper	Male	Later	Yes
14	2000	Crimson Avenger	Male	None	No
15	2000	Crimson Fox	Female	Birth	No
16	2000	Doctor Fate	Male	Later	Yes
17	2000	Doctor Light	Female	Later	No
18	2000	Doctor Mid-Nite	Male	None	No
19	2000	Dove	Male	Later	Yes
20	2000	Elongated Man	Male	Later	No
21	2001	Etrigan	Male	Later	Yes
22	2001	Fire	Female	Later	Yes
23	2001	Flash	Male	Later	Yes
24	2001	Green Arrow	Male	None	Yes
25	2001	Gypsy	Female	Birth	No
26	2001	Hawk	Male	Later	Yes
27	2001	Hawkgirl	Female	Birth	Yes
28	2001	Hourman	Male	Later	No
29	2001	Huntress	Female	None	Yes
30	2001	Ice	Female	Birth	No

[MacroHardOnFire]

31	2001	Johnny Thunder	Male	Later	No
32	2001	Long Shadow	Male	Birth	Yes
33	2001	Martian Manhunter	Male	Birth	Yes
34	2001	Metamorpho	Male	Later	Yes
35	2001	Mr. Terrific	Male	None	Yes
36	2001	Nemesis	Male	None	No
37	2001	Obsidian	Male	Birth	No
38	2001	Orion	Male	Birth	Yes
39	2001	Plastic Man	Male	Later	No
40	2001	Question	Male	None	Yes
41	2002	Ray	Male	Birth	No
42	2002	Red Tornado	Male	Birth	No
43	2002	Rocket Red	Male	None	No
44	2002	S.T.R.I.P.E.	Male	None	Yes
45	2002	Sand	Male	Later	No
46	2002	Shining Knight	Male	None	Yes
47	2002	Speedy	Male	None	No
48	2002	Stargirl	Female	None	Yes
49	2002	Starman	Male	None	No
50	2002	Steel	Male	None	Yes
51	2002	John Stewart	Male	None	Yes
52	2002	Supergirl	Female	Birth	Yes
53	2002	Superman	Male	Birth	Yes
54	2002	Vibe	Male	Birth	No
55	2002	Vigilante	Male	None	Yes
56	2002	Vixen	Female	Later	Yes
57	2002	Waverider	Male	Later	No
58	2002	Wildcat	Male	None	Yes
59	2002	Wonder Woman	Female	Birth	Yes
60	2002	Zatanna	Female	Birth	Yes