Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to hide value in Matrix when not expanded/collapsed?

how not to show value in matrix column?

If not expanded i want it to be blank, then when i collapsed i will see the value.

 

 

thanks in advance

General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • rubayatyasmin's avatar
    rubayatyasmin
    2 years ago

    Hi, Anonymous 

    you can try to match the text color to the background so that it looks blank, that could be a woraround. or you can use ISINSCOPE dax func to determine your your current level of drill down. 

     

    for example,

    Measure = 
IF(
   ISINSCOPE(Table[YourColumnName]), 
   SUM(Table[YourValueColumn]), 
   BLANK()
)

     

    refer: https://learn.microsoft.com/en-us/dax/isinscope-function-dax

3 Replies

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    2 years ago

    Hi, Anonymous 

    you can try to match the text color to the background so that it looks blank, that could be a woraround. or you can use ISINSCOPE dax func to determine your your current level of drill down. 

     

    for example,

    Measure = 
IF(
   ISINSCOPE(Table[YourColumnName]), 
   SUM(Table[YourValueColumn]), 
   BLANK()
)

     

    refer: https://learn.microsoft.com/en-us/dax/isinscope-function-dax

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    got it thank you

    • rubayatyasmin's avatar
      rubayatyasmin
      Community Champion
      2 years ago

      if my answer is helpful then accept it as a solution and why not give it a kudos.