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!
Conditionally format the row header of a matrix chart
How do I conditionally format the row header of a matrix chart in Power BI? I have a matrix chart where: In "Lines" I inserted the data from two columns of table 1. (Ex: Columns: A and B) In "Columns" I inserted another column from table 1 (Ex: Column C) and a column from table 2 pulling the months (Ex: Column D). In Values, insert the sum of two columns ( E and F ) from table 1. I want to format all the lines, both the header lines and the value lines so that whenever the word "total" appears, the background color changes. I was able to do this in the value fields by inserting a measure in the "conditional formatting" option using this DAX formula: "Format 1 = IF(CONTAINSSTRING(SELECTEDVALUE(TABLE1[COLUMN A]), "TOTAL"), "#CCCCCC", BLANK())" But I'm not able to format the line headers this way. All the tutorials I see are related to column formatting, column headers and values...
