How to hide value at drill down level?

[tvaishnav]

How do you hide the highlighted values? Those values make sense at contract level but has no meaning on date level.

[truptis · Accepted solution]

There is as sticky tape solution to this:
considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS

[visheshjain]

Hi @tvaishnav,

Have you tried using the ISINSCOPE() function, with the if condition?

This way you can return blanks for the levels you do not want the measure to be calculated.

Here is a link which has a YouTube video as well:

ISINSCOPE - DAX Guide

Hope this helps and if it does, please Kudo it or mark it as the best answer so that others can reach the solution faster.

Thank you,

Vishesh Jain

[truptis · Accepted solution]

There is as sticky tape solution to this:
considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS

[Anonymous]

Nice explanations Trupti 

[tvaishnav · Accepted solution]

I thought about this but was wondering if there was a better way. I am marking this as solution. Thanks!