Matrix Column Conditional Formatting

[MStark]

Hi All,

Im trying to have conditional formatting on a full column but having trouble since it only goes on the Values and Totals but the first row on each level is not being formatted. 

Format Flag1 =

VAR Level1 = SELECTEDVALUE('Intacct Path'[Level 1])

VAR MonthYear = SELECTEDVALUE('All Dates'[Month-Year])

RETURN

    SWITCH(

        TRUE(),

        MonthYear = "YTD" , 3,

        Level1 = "Net Income", 2,

        0

    )
Any help/ideas will be appreciated! Thanks in advance!

[v-venuppu]

Hi @MStark ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu]

Hi @MStark ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Elena_Kalina @lbendlin @FBergamaschi for the prompt response.

You are correct - row headers can't be conditionally formatted because they don't have data context. A workaround is to create a dummy measure (like your FormatFlag1) and add it to the Values area, then apply conditional formatting based on that.

If your goal is to highlight Month vs YTD columns, another option is to split them into two separate matrix visuals side by side, each with its own formatting.

Unfortunately, formatting row headers directly isn’t supported yet.

If you still need this feature,I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels using the link below:

Fabric Ideas - Microsoft Fabric Community

Thank you.

[MStark]

@Elena_Kalina, @lbendlin and @FBergamaschi Thanks for taking the time to respond!!

As @lbendlin mentioned, there is no data there as its a row header (totals are set to be on the bottom) which is why the measure wont generate anything on that line. Was wondering if theres another way to get this column formatting as we need to differentiate between the month column and the YTD column. Or if formatting is not possible, any other ideas?

Thanks in advance!

[Elena_Kalina]

Hi @MStark 

Make sure the correct aggregation is set for this measure (typically "Sum" for financial data), and also check the "Subtotals" settings—they should be enabled for the top level.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[lbendlin]

There is nothing there so you cannot apply a format either.  Consider using tabular layout to not have that blank space.

[FBergamaschi]

I would test the formula putting the column FormatFlag1 in the visual to see the value returned where you get no format

I am not expert of formatting but looking at the formula you will get a 0 wherever is not formatted and I do not see a rule for that value in your screenshots

Should not you include also "Revenues" for Level 1, for example, to get the value 2?

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI