Two Matrix Questions

[Razorbx13]

Two questions that hopefully have answers:

1.  The Plus (+) and Minue (-) icons for rows in a Matrix.  Is there a way to show this by Row?  I want to allow users to expand out certain Account Groups, but not see that option for others.  Example:  Expand Revenue Group row?  Yes.  Expand Gross Margin row?  No.

2.  Conditionally formatting a row header.  Similar to this, I would like to format specific rows in may matrix.  I can format the measures fine to a different shade of color, but want to match that on the row header for that row and leave all the others the same.  Is this possible?

Thanks in advance!

[selimovd]

Hey @Razorbx13 ,

about your questions:

1. Sadly not, you can either activate or deactivate them, but just for all rows. You cannot differentiate

2. The headers cannot be formatted as the conditional formatting is about values and the header doesn't have values.

Sorry for that.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Razorbx13]

Thank you. I was hopi g I could change the background of the values and then apply to label like you can do for all total rows.  For me it is just a few of the subtotal rows of the matrix I need to do this.  Leave all the others as a default. 

[Anonymous · Accepted solution]

Hi @Razorbx13,

Nope, current power bi matrix visual not support these summary rows. Its total row is analyzed by power bi and grouped based on category fields.

For your scenario, you need to create a new table with subcategory type and custom fields, then write measure expression to replace row value field to use the current value switch function to show different values.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH 
Regards,

Xiaoxin Sheng