Forum Discussion

Guo's avatar
Guo
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago
Solved

Gantt

I added a Gantt chart on Power BI Desktop, and there are other visual charts on my page. Strangely, the Slicer I made with the parent ID can filter the Gantt chart, but if the same field is placed in the table and only one parent ID is selected, the Gantt chart will not change because other charts can interact with each other

  • Yes, that’s correct. The issue likely stems from the Gantt chart being a custom visual, which may not fully support interactions between charts like the default Power BI visuals.

    Custom visuals often have limitations in their interaction behavior, depending on how they are developed. Try using some other different visual such as using a matrix visual, stacked bar chart, that might better integrate with other visuals.

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

9 Replies

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi Guo 

    Thank you for reaching out to Microsoft Fabric Community.

     

    1. The Gantt chart in Power BI is typically a custom visual. It is not one of the default visuals included in Power BI Desktop out of the box.
    2. Since Gantt chart is a custom visual, check its filtering settings. The custom visuals may not fully support all Power BI interactions by default.
    3. Custom visuals rely on third-party development, and bugs may occur if they aren't updated frequently. Ensure it is the latest version; Custom visuals can sometimes have bugs in interaction behavior.
    4. Try using some other different visual e.g., a matrix or another table that might better integrate with other visuals.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    • Guo's avatar
      Guo
      Icon for Microsoft Employee rankMicrosoft Employee
      So I understand what you mean is that there is a problem with the Gantt I am using, as it does not fully support interaction between charts like the default visual controls
      • v-achippa's avatar
        v-achippa
        Icon for Community Support rankCommunity Support

        Yes, that’s correct. The issue likely stems from the Gantt chart being a custom visual, which may not fully support interactions between charts like the default Power BI visuals.

        Custom visuals often have limitations in their interaction behavior, depending on how they are developed. Try using some other different visual such as using a matrix visual, stacked bar chart, that might better integrate with other visuals.

         

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

  • Hi Guo ,
    The issue you're encountering likely stems from the interactions between visuals on your Power BI report page. Specifically, when you select a Parent ID in the table visual, the interaction between the table and the Gantt chart may not be configured properly.

    Here’s how you can try to fix it:

    1. Enable Visual Interactions:
      • On the Power BI Desktop, go to the top ribbon and click on Format → Edit Interactions.
      • This will activate interaction controls between visuals on your report page.
    2. Configure the Table-to-Gantt Interaction
      • Click on the table visual (where the Parent ID is selected).
      • Look for interaction icons on top of the Gantt chart visual:
        • A filter icon (🪟) allows filtering.
        • A no filter icon (🚫) disables interaction.
    3. Test Interactions
      • Select a Parent ID in the table visual.
      • Verify that the Gantt chart filters correctly based on the selected Parent ID.

    I hope the provided solution works for you

    If I have resolved your question, please consider marking my post as a solution. Thank you!
    A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.

    • Guo's avatar
      Guo
      Icon for Microsoft Employee rankMicrosoft Employee

      Thank you for your answer. I think I may not have expressed myself clearly. For all the visual charts on my page, I have enabled chart interaction by default. The slicers on the page can interact with Gantt, and the slicers can also interact with the tables on the page. However, when I select a Parent ID in the table, all the data on the page will change by default, but Gantt will not change at all (these data come from the same table, so there is no need to connect tables). I have not found any solution to this problem yet

  • Guo , Check the edit interaction between Table and Gantt chart. Make sure when you select "Table" visual and check the edit interaction with Gantt chart. It should be not be "None".