Hide certain row headers

[kirby001]

I have a matrix in that is essentially a league table of metrics by staff member. This table is going to be used in 1-1s so will be shown to the staff member. I want to be able to select a staff member and have this staff members name be the only row header visible in the matrix but still have the other rows and metrics visible so they can be used as a comparitive league table.

I have considered making a measure to conditionally format the row heads but row headers cannot be conditionally formatted as far as i can see. Is this acheiveable?

[kirby001 · Accepted solution]

Thanks for the response, not quite what I was after but very useful.

I have managed to self solve so adding my solution in case its helpful to anyone going forward.

Blanked out all the actual metrics here but when a primary_resource is selected in the slicer, the table matrix remains unchanged other than the unselected primary resources are now blank. This allows this to be used as a "league table" while keeping the unselected names confidential.

This has been acheived by hiding the row headers entirely and using a measure to create row headers instead. Measure as follows

Selected_Primary_Resource = 
VAR FilterName = IF(
    HASONEVALUE(Provisioner[Primary_Resource]),
    VALUES(Provisioner[Primary_Resource]),
    BLANK()
)
RETURN
IF(
    HASONEVALUE(OT_Temp[Primary_Resource]),
    IF(
        ISBLANK(FilterName),
        VALUES(OT_Temp[Primary_Resource]),
        IF(
            VALUES(OT_Temp[Primary_Resource]) = FilterName,
            VALUES(OT_Temp[Primary_Resource]),
            BLANK()
        )
    ),
    BLANK()
)

The provisioner table is an unlinked table so when a single provisioner is selected, only their name appears and the others are blank.

Sorry if the explanation is rubbish. Hope this helps someone in future. Would be great if powerbi could add conditional formatting options to row headers so this would be much simpler to achieve.

[danextian]

Hi @kirby001 ,

This might be what you need. The approach uses a disconnected table which is simpley a copy of the column headers and then a measure to return a value only if not disconnected table selection.

Sample Measure

Total Revenue2 = 
CALCULATE (
    [Total Revenue],
    FILTER ( VALUES ( Geo[Geo] ), NOT Geo[Geo] IN VALUES ( Geo2[Geo] ) )
)

Please refer to attached pbix for the details.