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.
     
     
v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi JennyMilf ,

Thank you for engaging with the Microsoft Fabric Community.

Just following up to check if your query has been resolved and whether the response from SamWiseOwl  was helpful. If so, please consider marking the helpful replies as Accepted Solutions to assist others with similar queries. If further assistance is needed, please reach out.
Thank you.