Forum Discussion

Joe_100's avatar
Joe_100
Icon for Helper I rankHelper I
8 years ago

Table visual, dynamically select multiple value

Hi all,   Maybe it's possible, maybe not. I have the following question: I have a table that looks a bit like this(overly simplified).   Company           Name                 ID Test1         ...
bizbi's avatar
bizbi
Icon for Advocate I rankAdvocate I
8 years ago

Instead of using a table visual where the user is selecting the name value, user should select from a merged column of 'Name' and 'ID'. This can be done in Query Editor:

 

i. Right click on 'Name' column and click on duplicate column.

ii. Right click on 'ID' column and click on duplicate column.

iii. Press control key on keyboard and select both the duplicated columns.

iv. Right click on the header of either of the selected columns and click Merge Columns.

v. Click on Close and apply changes in Home tab.

 

Now using this merged column would help you select the exact records you need.

 

Hope this helps!

  • Joe_100's avatar
    Joe_100
    Icon for Helper I rankHelper I
    8 years ago

    Hi bizbi,

     

    thanks for your reply, although i'm not sure if we are on the same page ;)

     

    What i try to achieve is maybe a bit more complicated, and i don't see how merging column will solve this.

     

    Let me try to explain what i want to achieve;

     

    I have one table and basically some records are related to each other.

    It doen's really mather what kind of visual i take (slicer,table,matrix) but at the moment i select a record in the visual it needs to search in that same table if there is a related record and also mark this record in the visual.

     

    I need a sort of lookup that starts on the moment of selecting something in the visual....

     

     

    Hope this helps a bit.

  • Joe_100's avatar
    Joe_100
    Icon for Helper I rankHelper I
    8 years ago

    Hi bizbi,

     

    thanks for your reply, although i'm not sure if we are on the same page ;)

     

    What i try to achieve is maybe a bit more complicated, and i don't see how merging column will solve this.

     

    Let me try to explain what i want to achieve;

     

    I have one table and basically some records are related to each other.

    It doen's really mather what kind of visual i take (slicer,table,matrix) but at the moment i select a record in the visual it needs to search in that same table if there is a related record and also mark this record in the visual.

     

    I need a sort of lookup that starts on the moment of selecting something in the visual....

     

     

    Hope this helps a bit.

    • bizbi's avatar
      bizbi
      Icon for Advocate I rankAdvocate I
      8 years ago

      Is it not possible to put a slicer using ID column?

       

      My best guess is that IDs are not user friendly so probably you need names.

       

      In such a scenario, a possible workaround is to put the ID slicer next to your existing table. Selecting a 'Select All' option on the ID slicer can do the trick.

      • Joe_100's avatar
        Joe_100
        Icon for Helper I rankHelper I
        8 years ago

        Thanks for the suggestion, unfortunetaly it's not working.

         

        If i select a record on the table it won't filter the slicer.

         

        I'm a bit afraid that what i want is not possible...