Forum Discussion

Newbie12345's avatar
Newbie12345
Regular Visitor
2 years ago

Matrix to Gantt chart

Dear Power BI Pros,

With the Matrix Visual (Vdo Reference - YouTube channel: How to Power BI),I'm trying to convert it into a Gantt chart.
I would appreciate some advice on how to make Matrix appear more readable by adding a straight line at the end of each week.

 

Thank you

3 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi Newbie12345 

     

    I love his videos.

     

    To your request.

     

    I would create a measure and this measure after the week in the visual. When you add the measure to the visual, rename it to a space and this will remove the name of the measure or you can change the colour of the fint to the same as your background.

     

    Please use this measure 

     

     

     

     

    and change the colour in the conditional formatting part to whatever you need.

     

    Hope this helps

    Joe

     

     If you found my answer helpful and it solved your issue, please accept as solution

    • Newbie12345's avatar
      Newbie12345
      Regular Visitor
      2 years ago

      Dear Joe_Barry ,

      I appreciate your consideration of my question and your time. Thank you so much for looking into it.
      I tried the same but unable to get the expected result, it would be really great if you could share the sample file.

      Best Regards!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Newbie12345 ,
    Many thanks to for your very quick and effective replies, and I will give some additions below:

    Based on my knowledge, try to create a custom Gantt chart.

    Select Gantt visual.

     

    You can also view the following links to learn more about make matrix to Gantt chart.

    Solved: Matrix to Gantt Chart Visualization - Microsoft Fabric Community

     

    Best Regards,

    Wisdom Wu

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