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

View solution in original post

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

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 118 members 1,439 guests
Please welcome our newest community members: