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 a...
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!