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

parry2k's avatar
parry2k
Super User
6 years ago

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'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)