Forum Discussion

JennyMilf's avatar
JennyMilf
Helper I
1 year ago
Solved

Dynamically changing visual based gantt chart selection

Hi everyone, I’m currently using the Gantt Chart by MAQ Software, and I’m looking for assistance in developing a dynamic visual that updates based on the selection in the Gantt chart. Example: Wh...
Need Help
Tips and Tricks
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi JennyMilf 
    You could use DAX to hide the data when the relevant piece is clicked:

    Hide sections Business =
    if(
        SELECTEDVALUE('Table'[Team Involved ]) <> "Business Analyst"
        ,Count('Table'[Task])
        ,BLANK()
        )
     
    Hide sections Engineer =
    if(
        SELECTEDVALUE('Table'[Team Involved ]) <> "Lead Engineer"
        ,SUM('Table'[Cost])
        ,BLANK()
        )
     
    You would also need to change the Title to hide the text.
     
     
SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi JennyMilf 
You could use DAX to hide the data when the relevant piece is clicked:

Hide sections Business =
if(
    SELECTEDVALUE('Table'[Team Involved ]) <> "Business Analyst"
    ,Count('Table'[Task])
    ,BLANK()
    )
 
Hide sections Engineer =
if(
    SELECTEDVALUE('Table'[Team Involved ]) <> "Lead Engineer"
    ,SUM('Table'[Cost])
    ,BLANK()
    )
 
You would also need to change the Title to hide the text.