Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Color Formatting on Matrix

  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 corr...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Something like below?

    Check

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

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)