Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Visual filtering

Hi   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 gr...
Need Help
Nishantjain's avatar
Nishantjain
Continued Contributor
7 years ago
Just to add to the previous suggestion, you need to unhide the synced slicer on the page

When you sync slicers across multiple page, each slicer is copied in each page but is hidden. You can unhide the slicer from the selection pane or sync slicer pane

Once you unhide the slicer, follow the instructions from the previous post and then hide the slicer again
Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks, I did this but it is still ommitting results. 


 

  • Nishantjain's avatar
    Nishantjain
    Continued Contributor
    7 years ago
    What do you mean that it is still ommitting results?

    A synced slicer works exactly the same way as a normal slicer so I expect it to work.

    You can also check this by creating a blank page and copy the 2 visuals you have. Make sure you don't sync any slicers. Now sync one slicer at a time and change it's interaction with the 2 visuals and analyse the impact. I am sure you will spot something
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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: 

      Name2 calculation = SUMX(Data,CALCULATE(SUM(Data[Utilisation]),USERELATIONSHIP('Employee List'[Name1 List],Data[Name2 Clean]),FILTER(All('Employee'),'Employee List'[Name1 List]=Data[Name2 Clean])))
       
      if you can help me get that one working then I think it will fix the visual issues as well.
      • Nishantjain's avatar
        Nishantjain
        Continued Contributor
        7 years ago
        Hi there,

        Need a bit more information. Can you share sample data screenshots and what exactly the measure is showing and what you expect to see