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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 179 members 1,800 guests
Please welcome our newest community members: