cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RashmitaR Member
Member

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

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.
1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

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

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.

1.PNG2.PNG

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

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

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

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.

1.PNG2.PNG

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