Forum Discussion
Super UserConditional formatting rules for totals and subtotals in Matrix and Table Visual
As per the documentation on CF, https://docs.microsoft.com/en-gb/power-bi/create-reports/desktop-conditional-table-formatting , it forces you to specify the Min and Max when you select the Values and Totals option in the Apply to dropdown.
I managed to figure it out and solve my problem by collapsing the entire level in the Matrix Row Hierarchy. The point to note here is that you will not see CF application on the parent level of the hierarchy if any child level is expanded. you need to close all child levels. Refer to this example below.
#1 with all levels collapsed, CF works here.
#2 One child-level expanded inside
#3 Expanded child level (Country causing the CF to stop)
Super UserPragati11
Not exactly,
As per my understanding, the documentation does not give enough information and clarify on the following note
"You must manually set the thresholds and ranges for conditional formatting rules. For matrices, Values will refer to the lowest visible level of the matrix hierarchy."