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
For example:
0 <= Green < 0.3
0.3 <= Yellow < 0.7
0.7 <= Red
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
Excellent!, that will be enough for my project.
Just to know...when you select [Kpi] column as Indicator in "KPI column type", there are colored circles according to red=1; orange=2; yellow=3; green=4. Could this be changed?
Thanks in advance!
- v-lili6-msft
hi, Anonymous
After my test, I'm afraid it couldn't achieve in Power BI for now. For it is the third party visual and it only has three types and it color couldn't be customized.
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
KPI Group = IF('Schedule & Milestone'[Task Status] = "Completed", 4, IF('Schedule & Milestone'[Task Status] <> "Completed" && TODAY() > 'Schedule & Milestone'[Modified Task Finish date], 1,if('Schedule & Milestone'[Task Status] <> "Completed" && TODAY() < 'Schedule & Milestone'[Modified Task Finish date], 3)))