Custom KPI in Gantt Chart by MAQ

[Anonymous]

Dear community,

I'm designing a gantt chart including the KPI column. I would like to customize the standard KPI ranges, i mean, red=1; orange=2; yellow=3; green=4, for other values.

Is there a way to do this?

Regards

[Anonymous]

For example:

0 <= Green < 0.3

0.3 <= Yellow < 0.7

0.7 <= Red

[v-lili6-msft · Accepted solution]

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

[shettydeepti09]

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)))

[Anonymous]

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