Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
hooleee
Regular Visitor

Why can`t my KPI visual show neutral color?

my data:

hooleee_0-1712631861244.png

hooleee_4-1712632020535.png

 

measure:

hooleee_1-1712631902781.png

field:

hooleee_3-1712631998429.png

 

card:

hooleee_6-1712632080122.png

 

hooleee_2-1712631930900.png

 

------------------------

why does it show yellow?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @hooleee ,

Based on the information you have provided, the problem you are having is that neutral colours are not being displayed. You should note that neutral colours only apply when there are two target values, if your metric is in between then it is neutral, if it is above the higher target then it is a "good colour" and if it is below the lower of the two targets then it is a "bad colour". I created a sample data for you that hopefully explains it better:

vyifanwmsft_0-1712713397766.png

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @hooleee ,

Based on the information you have provided, the problem you are having is that neutral colours are not being displayed. You should note that neutral colours only apply when there are two target values, if your metric is in between then it is neutral, if it is above the higher target then it is a "good colour" and if it is below the lower of the two targets then it is a "bad colour". I created a sample data for you that hopefully explains it better:

vyifanwmsft_0-1712713397766.png

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks for your answer! 😄

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.