Hide +/- on specific rows on matrix

[Anonymous]

Hi, I would like to enable drill down only on specific rows on my matrix. 

Only a few values has to be drilled down, like 'Other' and 'Double Ended'. I would like to hide '+/-' for values like 'fresh' that return blank rows if drilled down. Is it possible ? 

Thank you

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

According to the official documentation, You can also add +/- buttons to the row headers through the formatting pane under the Row headers card, but you cannot specify a Rows, they all disappear or appear together:

Create matrix visualizations in Power BI

If you have an idea about this, you can go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.

“'fresh' that return blank rows if drilled down”

Here are the steps you can follow：

1. Create measure.

Measure 2 =
IF(
    NOT(ISFILTERED('Table'[Affinity1])),
    MAX('Table'[Group]),
    IF(
        FIRSTNONBLANK('Table'[Affinity],1) <> "fresh",MAX('Table'[Group])))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly