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
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
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
if my answer is helpful then accept it as a solution and why not give it a kudos.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
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
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
