Dynamically changing visual based gantt chart selection

[JennyMilf]

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:

• When selecting "Business Analyst" in the Gantt chart, the report should display Selection 01 chart and hide or disable Selection 02 chart.
• When selecting "Leader Engineer" in the Gantt chart, the report should display Selection 02 chart and hide or disable Selection 01 chart.

Can anyone please help me to implement it? Thanks

Please refer to my dashboard to download the necessary files

[v-veshwara-msft]

Hi @JennyMilf ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @JennyMilf ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft]

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.

[SamWiseOwl · Accepted solution]

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.