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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Conditional Formatting to One value in a column

Hi All,

 

Is there any way I can apply conditional formatting to the only YTD in a Period type field?

Actuals Greater than Full Year plans then Red else Green. Currently, it's applying for all WTD, MTD, and YTD. but I need the formatting should only for YTD.

 

 Conditional Formatting.png 

 

 

Regards,

Ranjan

 

 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @RanjanThammaiah 

 

Try to create a measure like below:

_Color =
IF (
    MAX ( 'Data'[Period Type] ) = "YTD",
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( Data[Actuals] ) > SELECTEDVALUE ( Data[Full Year Plan] ), "Red",
        "Green"
    )
)

Sample:

v-angzheng-msft_0-1621491884976.jpeg

v-angzheng-msft_1-1621491884978.jpeg

 

Result:

v-angzheng-msft_2-1621491884981.jpeg

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

 

Best Regards,
Community Support Team _ Zeon Zheng
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
v-angzheng-msft
Community Support
Community Support

Hi, @RanjanThammaiah 

 

Try to create a measure like below:

_Color =
IF (
    MAX ( 'Data'[Period Type] ) = "YTD",
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( Data[Actuals] ) > SELECTEDVALUE ( Data[Full Year Plan] ), "Red",
        "Green"
    )
)

Sample:

v-angzheng-msft_0-1621491884976.jpeg

v-angzheng-msft_1-1621491884978.jpeg

 

Result:

v-angzheng-msft_2-1621491884981.jpeg

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@RanjanThammaiah , You can but a condition like

With help from conditional formatting measure you can do

 

color =

if(max(Period Type]) ="YTD" ,

Switch ( true()

[Measure] < 100000 ,"red",

// add conditions 

"Green"

), "White")

 

 

Use in conditional formatting using field value option

 

refer for steps

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.