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
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!
Community Supporthi, 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