How to use a property control to dynamically change only one column of my cross table

[Samuel Mascarenhas 2]

I have a dashboard with 5 different visualizations: Scatter plot, 2 bar charts, Map and a cross table. I am trying to have a property control to dynamicaly change the values in every visualizations. I have created a property control with Column Selection as well as Expression and both worked well with the scatter plot and Bar charts, however it is not working with Cross table and MAP. I wonder if somebody can help please

My cross table without the property control works like below the table below, but I want ot use a property control to change the second colum from Type to Colour (2 different columns). All other columns should remains as it is.

 

 

 

 

Type

 

 

 

 

Code

Colour

Units

City

 

 

101

3

23

London

 

 

202

8

22

Oxford

 

 

303

4

20

Birmingham

 

 

505

5

25

Brighton

 

 

707

8

28

Manchester

 

 

808

9

7

Liverpool

[Kirsten Smith (she/her)]

What does your expression look like in the cross table for that axis  You might need to update how you are calling your document property.

[Samuel Mascarenhas 2]

for the cross table It is a basic Sum([Colour]) and Sum([Type]).

my property control was first a column selection but then a custom expression same way I am creating for the cross table