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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
THENNA_41
Post Partisan
Post Partisan

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

@THENNA_41 , 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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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 . 

@THENNA_41 , 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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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