Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Newbie12345
Regular Visitor

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.

Newbie12345_1-1711091841323.png

 

Thank you

3 REPLIES 3
Anonymous
Not applicable

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.

vjiewumsft_0-1711968160806.png

vjiewumsft_2-1711968311088.png

 

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.

Joe_Barry
Super User
Super User

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 

 

Joe_Barry_0-1711095526777.png

 

 

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn


Let's connect on LinkedIn


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!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.