Forum Discussion
Create a dynamic column based on slicer selection
I have two tables: Table 1 ColumnA ColumnB A1 B1 A2 B2 A3 B3 Table 2 Column Types ColumnA ColumnB I have a slicer for Columns Types and based on selection...
ColumnC Measure =
SWITCH(
MAX('Table 2'[Column Types])),
"ColumnA",MAX('Table 1'[ColumnA]),
"ColumnB",MAX('Table 1'[ColumnB]),
BLANK()
)Thanks for your reply Greg. But I want to use ColumnC as a slicer anda measure cant be used as a slicer.
Also, using column C as an independent column shows only the maximum value for the column selected in the slicer.
- Columns cannot be dynamic based upon user selection. Just use the disconnected table trick to use your measure as a slicer.
What is "the disconnected table trick"?
