Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
For example:
0 <= Green < 0.3
0.3 <= Yellow < 0.7
0.7 <= Red
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
Is there a way to show KPI indicator as blank for rows which start with schedule in below chart. This is the KPi logic
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
121 | |
76 | |
71 | |
56 | |
47 |
User | Count |
---|---|
161 | |
84 | |
68 | |
66 | |
61 |