cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 from that filter a ColumnC should be created in the table - Table1.

Eg., If i select ColumnA in the filter, my Table1 should look like this:

New Table1

 ColumnA ColumnB ColumnC A1 B1 A1 A2 B2 A2 A3 B3 A3

If i select ColumnB in the filter, my Table1 should look like this:

New Table1

 ColumnA ColumnB ColumnC A1 B1 B1 A2 B2 B2 A3 B3 B3

The final goal is to create a slicer with ColumnC as well and it will show values based on selected value in Column Types slicer.

5 REPLIES 5
Microsoft Employee

A bit change to Greg_Deckler's DAX.

```ColumnC Measure =
SWITCH(
MAX('Table 2'[Column Types]),
"ColumnA",MAX('Table 1'[ColumnA]),
"ColumnB",MAX('Table 1'[ColumnB]),
BLANK()
)```

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
```ColumnC Measure =
SWITCH(
MAX('Table 2'[Column Types])),
"ColumnA",MAX('Table 1'[ColumnA]),
"ColumnB",MAX('Table 1'[ColumnB]),
BLANK()
)```

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

@Greg_Deckler

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.

Super User
Columns cannot be dynamic based upon user selection. Just use the disconnected table trick to use your measure as a slicer.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

What is "the disconnected table trick"?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.