Conditional formatting does not work when drill down on matrix

[metxtli]

I'm using the last version matrix using a conditional formatting in a column. It works well, but when I start to drill-down the conditional formatting is not working.

 

I'm calculating the colum with 1 or 0((Blank)😞 

% PUR = if ([% Var vs LM(ABS)] > [selectedValue], 1, BLANK())

SelectedValue represents the % that I want to compare to. 

Then the conditional formatting like:

The problem is when I start to drill, the header group are not formatted and I can see the result 1 or 0 (Blank)

Any suggestions?

Regards

JCarlos

[v-chuncz-msft · Accepted solution]

@metxtli,

As I mentioned above, those are subtotals.

[v-chuncz-msft]

@metxtli,

For your requirement of conditional formatting for subtotals and total, you may vote this idea up.

[metxtli]

Thanks! I already voted the idea. My problem is that in some level of drill down the format stop.

Regards

JCarlos 

[v-chuncz-msft]

@metxtli,

I can not reproduce the issue. If convenient, share us the .pbix file.

[metxtli]

Hi, 

This is the example:

.pbix file

After I start to drill down.

Thanks in advance

JCarlos

[v-chuncz-msft · Accepted solution]

@metxtli,

As I mentioned above, those are subtotals.

[metxtli · Accepted solution]

Now I understand, thanks!