Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Time line visual using gantt or any visual like matrix

Hello Dear Power BI buddies
Following is my raw data 

IDcontracttypeshould startshould endactual startactual end
1A1/2/20232/3/20231/4/20232/18/2023
2B1/20/20222/19/20221/22/20223/8/2022
3A4/20/20235/20/20234/22/20236/6/2023
4C4/21/20235/21/20234/23/20236/7/2023

 

 

 

I want to make a time line visual like this 

 

and if the contract is on perfect time then it should be green or else it should sjpw red bars 

 

 

Please help
i will appreciate any help