cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Steffano
Frequent Visitor

KPI Visual Conditional Formatting

Steffano_0-1659957860716.png

Steffano_1-1659957887085.png

I'm trying to get my KPI visual to show amber for a range of values. I tried using the trend axis conditional formatting to achieve that, however, it doesn't seem to give me the desired outcome. It's still showing colors based on whether the KPI is above or below the target. Any help? Anyone?

@po 

1 ACCEPTED SOLUTION
Duia
Resolver II
Resolver II

Hi  @Steffano ,

You can set dynamic colors for the corresponding regions by clicking the fx flag in Format - Trend axis or Target value.

Duia_0-1660198653923.png

Duia_1-1660198653925.png

Here are the steps you can follow:

Duia_2-1660198653926.png

If you want the color and Value of the later trend graph to change, you can create a measure.

1. Create measure.

color =
IF(
    [Measure 2] >=1&&[Measure 2]<=14,"amber","yellow")

2. Trand axis – Bad color -fx.

Duia_3-1660198653927.png

Duia_4-1660198653929.png

3. Result:

Duia_5-1660198653929.png

 

Best Regards,

Liu Yang

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

1 REPLY 1
Duia
Resolver II
Resolver II

Hi  @Steffano ,

You can set dynamic colors for the corresponding regions by clicking the fx flag in Format - Trend axis or Target value.

Duia_0-1660198653923.png

Duia_1-1660198653925.png

Here are the steps you can follow:

Duia_2-1660198653926.png

If you want the color and Value of the later trend graph to change, you can create a measure.

1. Create measure.

color =
IF(
    [Measure 2] >=1&&[Measure 2]<=14,"amber","yellow")

2. Trand axis – Bad color -fx.

Duia_3-1660198653927.png

Duia_4-1660198653929.png

3. Result:

Duia_5-1660198653929.png

 

Best Regards,

Liu Yang

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors