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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
RAYAN123
New Member

Conditional formatting for matrix column headers based on closed month

Hi all,

I am working with a Power BI matrix where I have months (January–December) displayed as column headers, as shown in the screenshot. no value will display, only the column

Kindly ask for below request solution

  • Dynamically change the background color of the column headers
  • If a month is financially closed → show green
  • If a month is still open → show grey

I have a DAX in my model (e.g., a measure or flag indicating whether a month is closed):

Closed Month Flag =
IF(
    SELECTEDVALUE('Time'[IsClosedMonth]) = TRUE(),
    1,
    0
)

so the challenge is only related to applying the formatting to the headers.

Thanks for support!
Screenshot 2026-06-18 095130.png

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors