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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

how to set color previous three Month One color and after three month set different color .

 i am using two measure in column previous month another next month  measures so i cant add conditional color . first previous three Month color should be yellow and after that its dark green.

 

Date = EOMONTH(MAX('DatePA'[Week Date]),-1) 

Measure = EOMONTH([Date],-3)

Up time =
CALCULATE (
    DIVIDE ( [calc op per day], [calc op per day manne] ),
    calender[Year],
    FILTER (
        'PA - E2PR',
        AND (
            'PA - E2PR'[Effective Date] < [Date],
            'PA - E2PR'[Effective Date] >= Measuress[Measure]
        )
    )
)

this three measure i am using for the column value previous month . any idea. previous month its yellow after three month its should dark green.  thanks in advance 
3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Is there a month in display. Assume there is month year coming in display from dat table

 

Color =

if(Max(Date[Date] ) > eomonth(today(),-4) , "Yellow", "green")

 

You can use the same in conditional formatting using field value option.

 

It can color rows of a column and total , not the heading

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak  i am using two measure in column fields so conditional formating not working. this value from Effective date .format (DD:MM:YY)  date format only . 

@Anonymous , In matrix conditional formatting, do not work on columns.

Can share what is expected output a screenshot

 

and a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Users online (27)