Colour code rows according to a column not shown in matrix

[Anonymous]

Hi, 

I have a column in a table called display type which has values sum and normal. I've built a matrix around this table.

I'd like to colour code display type values for sum but i don't want the column display type to be shown on the matrix. 

Is there a way to do this?

Thank you.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Please create a measure and add it to Conditional formatting rule as below.

Measure = IF(SELECTEDVALUE('Table'[type])="sum",1,0)

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous]

@v-jayw-msft I don't see the measure in the conditional formatting part. Do I have to add this to the visual (which i don't want to do).

Thank you.

[v-jayw-msft]

Hi @Anonymous ,

You don't need to add the measure to visual.

Please check this pbix.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[VasTg]

@Anonymous 

Need little more information to answer your question.If you only want to conditional format display type -sum, you could use the selected value inside switch statement to check "display value =sum" and set the hex color code else none. Then you could use this measure in conditional format.

Refer to the documentation.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Show us the expected output. 

If this helps, mark it as a solution

Kudos are nice too