Return an entire column in a Data segment

[demian-cr]

Hello everyone.

I would like to set a Data segment where, depending of the Filter of another one, an specific column of my database appears.

Example: 

If in Data segment 1, I select the choice one, then the Data segment 2 have to show the column "1".

If in Data segment 1, I select the choice two, then the Data segment 2 have to show the column "2".

Etc.

How can I do this?

Thanks a lot for your help.

Regards.

[v-kelly-msft]

Hi @demian-cr ,

Could you pls provide some sample data with expected output to make your requirement clear?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[demian-cr]

Hello @v-kelly-msft 

Thanks a lot for your help.

For example:

I have a dropdown list, and near to it, I have a table that only shows an specific field of the table.

Then, if I change the choice selected in the dropdown, I would like that the data segment where the table is, shows another field.

I mean, each time the choice of the dropdown change, the field showed in the table has to change too.

Do I explain myself?

Regards.

[Syndicate_Admin]

Hi  @demian-cr ,

I made a simple table as below:

First create an index column in query editor;

Then suppose col1 is the defaulting showing column,create a measure as below:

Measure = 
IF(NOT(ISFILTERED('Table (2)'[Column1])),MAX('Table'[Col 1]),SWITCH(SELECTEDVALUE('Table (2)'[Column1]),
"Col 1",MAX('Table'[Col 1]),"Col 2",MAX('Table'[Col 2])))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft · Accepted solution]

Hi  @demian-cr ,

I made a simple table as below:

First create an index column in query editor;

Then suppose col1 is the defaulting showing column,create a measure as below:

Measure = 
IF(NOT(ISFILTERED('Table (2)'[Column1])),MAX('Table'[Col 1]),SWITCH(SELECTEDVALUE('Table (2)'[Column1]),
"Col 1",MAX('Table'[Col 1]),"Col 2",MAX('Table'[Col 2])))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!