Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

visual not filter the other visuals

Hello everyone

I'm having an annoying problem and would love to help

Visual number 1 = employees
Visual number 2 = membership

When I click on Visual Number 1 I actually see the companies he worked on in Visual 2

The problem is when I click on Visual 2 nothing happens.
(I would like Visual 1 to present the employees of their choice in the company)

All data come from the same table so there is no need for interactions
edit intarction is enabled in all

 

Each company is a coulm in itself

Attaches pictures of the data

 

visual 1                                                                                           

 

visual 1 Data

 

 

 

 

 

In Shared axis - its name of the employees

 

In column values - companys

 

 

 

 

 

 

 

 

 

Visual 2

 

 

 

 

 

 

 

 

Visual 2 Data

  • Hi,

    In the Query Editor, you will need to select the first 4 columns and last 2 columns.  Then right click and select "Unpivot other columns".  Now build your desired visual.

5 Replies

  • netanel , Difficult to tell without looking at data. Share the formula you are using. If are using all in the measure used in second visual, that can be another region.

     

    Also share interaction sreenshot , when second visual is selected

    • netanel's avatar
      netanel
      Icon for Post Prodigy rankPost Prodigy

      I enclose a picture of the DATA
      Its  simple C =  companies
      E = employess

       

      Thanks

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

        Hi,

        In the Query Editor, you will need to select the first 4 columns and last 2 columns.  Then right click and select "Unpivot other columns".  Now build your desired visual.