Dax conditional format

[Syndicate_Admin]

Good day everyone,

I hope you can help me with the following formula dax, I have a matrix that I want to paint as long as the month of the column (MRP Resin [Attribute]) matches the month of the row (MRP Resin [Name of the Month])

Thanks a lot

[v-rongtiep-msft · Accepted solution]

Hi @Syndicate_Admin ,

You can use the following DAX formula to paint the matrix as long as the month of the column (MRP Resin [Attribute]) matches the month of the row (MRP Resin [Name of the Month]):

f=IF(MONTH([MRP Resin [Attribute]]) = MONTH([MRP Resin [Name of the Month]]), table[value])

This formula checks if the month of the column matches the month of the row. If it does, it returns "Paint", otherwise it returns an empty string.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.