Forum Discussion
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
- amitchandak
Super User
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
Post Prodigy
I enclose a picture of the DATA
Its simple C = companies
E = employessThanks
- netanel
Post Prodigy
- Ashish_Mathur
Super 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.