Forum Discussion

demian-cr's avatar
demian-cr
New Member
5 years ago
Solved

Return an entire column in a Data segment

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.

Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

     

4 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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's avatar
      demian-cr
      New Member
      5 years ago

      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.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        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!