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 ...
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!

     

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!

       

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      5 years ago

      Hi  @demian-cr ,

       

      I made a simple table as below:

      vkellymsft_0-1627466690130.png

      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:

      vkellymsft_1-1627466982965.pngvkellymsft_2-1627466990120.png

      For the related .pbix file,pls see attached.

       

      Best Regards,
      Kelly

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