Forum Discussion
Hide +/- on specific rows on matrix
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
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
1 Reply
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