I have a dashboard built in which there is two slicers on the main page, these slicers control the the filters for all other pages and are synced.
on one page I have two visuals. One is a graph and the other is a details table (i.e customer details).
I want the graph to filter the details table, but I want the Details table to ignore all other slicers and just use the graph. is this possible?
Click the graph visual, then click Format-> Edit interactions, then select the disable icon in right-top hand of the two slicer visuals.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I created a new filter, basically there is an issue with where it is pulling the data.
I have two tables both with the ID of Name, I have them both linked to the main data table as a relationship but it appears as though this isn't working correctly
the only reason I hav two tables in the first place is because I can't get a calculation to work in the main employee table. the table has a column for names, but there are two corresponding columns in the main data table. so the relationship that I have is between the Table-Name column and the Data-name1 column. so my second formula which is meant to check the Data-Name2 column, is the one that isn't working.
so I created a whole new table, created the relationship and then the formula worked. but now its not showing the right customer details in the visuals. if I could somehow get the formula to work then I could get rid of the second table and the problem would be solved.
the formula I wrote as a measure is:
ok so here is a sample of what i've built so far:
|Main Data Table|
|Customer||Utilisaton||Emp Name 1||Emp Name 2|
|Cust 1||10%||Joe Bloggs|
|Cust 2||15%||Jane Bigs||Joe Bloggs|
|Cust 3||10%||Joe Bloggs|
|Cust 4||20%||Jane Bigs||Joe Bloggs|
|Cust 5||10%||Jane Bigs|
|Cust 6||15%||Jane Bigs|
Employee table 1 which has a relationship to Data Table Emp Name 1, this runs a calculation that looks for the Emp Name in the data table Emp Name 1 column and then sum the utilization associated. I've also used it to bring through the results from a second table and create a total (this is the part I want to change)
|Emp List table 1|
|Emp Name1||Utilization||Emp 2 Utilization||Total Utilization|
Employee Table 2, has a relationship with Data Table Emp Name 2, does the same as the first table simply calculates the utilzation based on finding the name in Emp Name 2.
|Emp Table 2|
Ideally I want to have one Employee table that does the calculation for all the utilization, but I can't work out how to have that work when I need to look in two different columns. (Emp Name 1 and Emp Name 2). and its not possible to combine the two as the names are the same and the reason for them being there is different.