Forum Discussion
Custom KPI in Gantt Chart by MAQ
hi, Anonymous
After my test, you may try to this way:
Step1:
Add a KPI group column like below:
KPI Group = IF(Table1[Kpi]>0&&Table1[Kpi]<0.3,"green",IF(Table1[Kpi]>=0.3&&Table1[Kpi]<0.7,"Yellow ","red"))
Step2:
Then drag the field into Category
Step3:
Custom color for the group in Format->Bar formatting
Result:
here is pbix, please try it.
https://www.dropbox.com/s/0kdwzqgqys83hdl/Custom%20KPI%20in%20Gantt%20Chart%20by%20MAQ.pbix?dl=0
Best Regards,
Lin
Community Supporthi, Anonymous
After my test, you may try to this way:
Step1:
Add a KPI group column like below:
KPI Group = IF(Table1[Kpi]>0&&Table1[Kpi]<0.3,"green",IF(Table1[Kpi]>=0.3&&Table1[Kpi]<0.7,"Yellow ","red"))
Step2:
Then drag the field into Category
Step3:
Custom color for the group in Format->Bar formatting
Result:
here is pbix, please try it.
https://www.dropbox.com/s/0kdwzqgqys83hdl/Custom%20KPI%20in%20Gantt%20Chart%20by%20MAQ.pbix?dl=0
Best Regards,
Lin
Is there a way to show KPI indicator as blank for rows which start with schedule in below chart. This is the KPi logic