Color Formatting on Matrix

[Anonymous]

I created a matrix with a with two row labels, product category and product and the two values (Capacity and On Hand) in the snapshot. I want to use one color for the product category and the corresponding values and another for the products and the corresponding values when the the dropdown is clicked. Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Something like below?

Check

Measure = IF(ISINSCOPE('Table'[product]),1,0)

Best Regards,

Jay

[Anonymous]

@Anonymous 

This is exactly what i need. Thank you so much.

[parry2k]

@Anonymous not sure what you are referring to when the dropdown is clicked? Can you provide a bit more context about what you are looking for?

[Anonymous]

@parry2k 

I'm sorry if i wasn't clear enough.  The snaphot below is what you see before clicking on the plus sign in a square found to the left of each product. My previous snapshot shows what it looks like when the plus sign has been clicked to view the products belonging to each product category. What i want is to use a different font color for each, one for product category labels and values then another font color for the product types and corresponding values when the dropdown is clicked. I hope this answers your question.

[harshnathani]

Hi @Anonymous ,

You can try this.

Measure = 
SWITCH(
    true(),
    ISINSCOPE(Product[ProductName]), 1,
    ISINSCOPE(Product[Product[Category]),2
)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)