Forum Discussion

dreaves1's avatar
dreaves1
Helper II
5 years ago

Visual Interaction not working

Hey, 

 

I have a report with a funnel visualization. For some reason when I select a data point on the visual it doesn't filter or highlight the other visuals on the report page. Also, whenI try to see the underlying data point as a table for a particular data point, it shows me all the data that make up the report instead of just the information that's associated the data point selected. What could I be doing wrong? 

 

 

5 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion

    dreaves1 

     

    Select the visual

    Go to Format and click the 'Edit Interactions' to see how filtering this object interacts with the other objects

    • dreaves1's avatar
      dreaves1
      Helper II

      Within the edit interaction for the funnel visual I've set the other visuals to filter but nothing happens.

       

  • dreaves1 , In funnel you have used all measures or you have used group with meaures ?

     

    if you have used all measure you wil get this kind of behaviour.

     

    if not.

    Can you a sample pbix after removing sensitive data.

    • dreaves1's avatar
      dreaves1
      Helper II

      No measure are applied. The funnel shows the number of candidates that made it through each step in the process. That have a 1 for each step they been in. Each step is a conditional column

       

       

       

       

      New StepHistorical Recruiter StepHistorical First InterviewHistorical  Second InterviewHistorical Offer StepHistorical Hire StepCandiate NameCapability
      1     John DoeBusiness
      11    Jane DoeIT
      111   Travis BakerEngineering
      111111Tony HawkEngineering
      11111 Travis PorterEngineering
      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support

        Hi dreaves1 ,

         

        Based on my test, you need to unpivot your source table and put all steps in on column :

         

        And put the new column to 'Group', it will interact as you want.

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai