Forum Discussion

aizamkamadin's avatar
aizamkamadin
Helper II
6 years ago

filter visual based on result from slicer

Guys, 

i want to generate staff workload (column graph) based on project selected using slicer.

the staff name on graph will be based on table 2 result.

 

 

 

Need Help

8 Replies

    • aizamkamadin's avatar
      aizamkamadin
      Helper II
      6 years ago

      cant, if i'm filter the column graph based on project.. it'll show every staff only have one project.

      what i want is, the slicer will filter visual/table no 2 and final result (column chart) will be based on result on table 2 (staff name)

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi aizamkamadin ,

         

        You may create a measure in table 'Project User' like DAX below, and put it into Values box of chart visual.

         

        Total Project Involved =
CALCULATE (
    COUNT ( 'Project User'[ProjectID] ),
    ALLEXCEPT ( 'Project User', 'Project User'[UserID] )
)

         

        Best Regards,

        Amy 

         

        Community Support Team _ Amy

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

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi   aizamkamadin ,

     

    Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy

    • aizamkamadin's avatar
      aizamkamadin
      Helper II
      6 years ago

      all have a same value..when im using ur code..

      if im using column chart with setting

      Axis = UserDetails.Name

      Value = Project_User.Count of User_ID

      the graph will show all like below

      (it'll show all users)

      what i want.. thegraph will filtered based on 2nd table

      e.g if we select project B >> table 2 will show on 3 person work on this project >> graph only show 3 persons workload