topic PowerBI - conditional formatting specific column section in matrix in DAX Commands and Tips

PowerBI - conditional formatting specific column section in matrix

AlexChitan — Tue, 09 Jul 2024 11:58:09 GMT

I have simplified my matrix table to the below.

Am I able to apply conditional formatting to the Variance section only? I want values to show as red for a negative variance and green for a positive variance. I can't find anything online that suggests you can.

Thanks

Re: PowerBI - conditional formatting specific column section in matrix

techhet23 — Tue, 09 Jul 2024 12:39:34 GMT

Hello AlexChitan,

As there is no straightforward solution to your problem, I have tried a workaround solution and it works well.

I tried to apply conditional formatting to cell using measure, where we can specify our "Variance" section condition effectively.

Have a look at all the 3 measures,

cf_variance_profit = IF(AND(VALUES(Sheet2[Quarter]) = "Variance", SUM(Sheet2[Profit]) >= 0), "#AFE1AF", IF(VALUES(Sheet2[Quarter]) = "Variance", "#E34234"))

cf_variance_cost = IF(AND(VALUES(Sheet2[Quarter]) = "Variance", SUM(Sheet2[Cost]) >= 0), "#AFE1AF", IF(VALUES(Sheet2[Quarter]) = "Variance", "#E34234"))

cf_variance_markup% = IF(AND(VALUES(Sheet2[Quarter]) = "Variance", SUM(Sheet2[Mark up %]) >= 0), "#AFE1AF", IF(VALUES(Sheet2[Quarter]) = "Variance", "#E34234"))

Hope this solves your problem, if it did don't forget to mark this as a solution.

Re: PowerBI - conditional formatting specific column section in matrix

AlexChitan — Tue, 09 Jul 2024 14:23:59 GMT

Amazing this has worked. Thank you!

Re: PowerBI - conditional formatting specific column section in matrix

selda — Fri, 06 Sep 2024 20:04:27 GMT

Hello,

I need help about matrix column totals.

I would like to have these kind of view but I can not view column total for each month .

gross sales, domestic sales... are measures on rows.

do you have an idea?

thanks