restricting the calculation of a measure beyond certain level for drill down

[RashmitaR]

Hi, I have created a matrix where in i have vertical Id,customer name and projects in my rows and have sales,sales target and sales % in my values where in I have applied conditional formatting to my sales %. My sales target has been calculated only at vertical Id level.My requirement is that when I drill down to customer name level I want the Target to show no values and hence do not want conditional formatting in the sales % column as I want sales% column to also show blank values.

[v-huizhn-msft · Accepted solution]

Hi @RashmitaR,

As I tested, in matrix visual, if we set the conditional formatting to one field, which will cover very level in the matrix. Please see the following screenshot, I set the sales field as conditional formatting.

For example, you set the sales target in conditional formatting, sales target will show the specific format bafore and after you drill down. We are unable to only set one level's format.

If this is not what you want, please share your sample data for further analysis.

Best Regards,
Angelia