Conditional format rows in a matrix table based on a measure

helen_p — Wed, 22 Mar 2023 14:24:57 GMT

Dear Power BI community

What I would like to achieve is

I want to create a matrix table where the headings of rows (which will be in a hierachy) are conditionally formatted based on the outcome of a measure. If the lowest row in the hierachy does not meet the condition of the measure, when the matrix table is NOT expanded, then the highest level in the table shows the same colour too

What is the data like

There are 3 columns which are in a hierachy Hospital >> Care Group >> Ward

I.e.

Hospital Care Goup Ward

SGH A 1

SGH A 2

SGH B 3

Measures

I have 2 measures called "Actual discharges" and "Expected Discharges" and when put together with the columns, it looks like this

Hospital Care Goup Ward Actual discharges Expected discharges

SGH A 1 3 2

SGH A 2 4 5

SGH A 3 3 2

SGH B 4 7 6

What to base the conditional format on

I wwas thinking of creating another measure where

if([Actual Discharges] <= [Expected Discharges], "Red", "Green")

Expected outcome

In a NON expanded matrix table Care group A would be red because Ward 2 still has an issue and is not meeting the expected number of discharges

Is this at all possible?

Re: Conditional format rows in a matrix table based on a measure

lbendlin — Fri, 24 Mar 2023 01:33:39 GMT

Not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

topic Conditional format rows in a matrix table based on a measure in Developer

Conditional format rows in a matrix table based on a measure

Re: Conditional format rows in a matrix table based on a measure