Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom KPI in Gantt Chart by MAQ

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

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    For example:

     

    0 <= Green < 0.3

    0.3 <= Yellow < 0.7

    0.7 <= Red

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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!