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

Slicers Change my Conditional Formatting Results

Thank you in advance! 

Background:

  1. Our training department provides an excel spreadsheet with employee training data. 
  2. My job is to take that spreadsheet and use Power BI provide managers a quick look at their employee performance.
  3. Employees above 95% on-time completion are considered to have achieved their goal and above 98% on-time completion are considered to have exceeded their goal.
  4. On-time completion is calculated, values are put in a matrix, and percent on-time is color coded based on the above.

The problem:

  1. The most important slicer is the one by manager name.
  2. If all managers are selected, conditional formatting works.
  3. HOWEVER, if one manager is selected, condtional formatting...breaks?!?!

Here is a screencap of the report and my conditional formatting setup: https://imgur.com/a/ihHJfaS

 

DAX Statements:

To assign a status per assignment: 

=if(isblank(Report[Transcript Completed Date].[Date]),if(date(year(Report[Transcript Due Date]),month(Report[Transcript Due Date]),day(Report[Transcript Due Date]))>=today(),"Open, Not Yet Due","Open, Past-Due"),if(date(year(Report[Transcript Completed Date])-7/24,month(Report[Transcript Completed Date]-7/24),day(Report[Transcript Completed Date]-7/24))>date(year(Report[Transcript Due Date]),month(Report[Transcript Due Date]),day(Report[Transcript Due Date])),"Completed Late","Completed On-Time")))
To calculate the percent on-time:
= if(CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed On-Time")/(calculate(counta(Report[Training Status]),Report[Training Status]="Open, Past-Due")+CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed Late")+CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed On-Time"))=0,0,CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed On-Time")/(calculate(counta(Report[Training Status]),Report[Training Status]="Open, Past-Due")+CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed Late")+CALCULATE(counta(Report[Training Status]),Report[Training Status]="Completed On-Time")))

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
New Member

I think I solved this! I changed by conditional formatting rules to numbers instead of percentages.

 

For example, "If greater than or equal to 0 'Number' and is less than 0.95 'Number' then 'Color Red.'" 

View solution in original post

1 REPLY 1
Highlighted
New Member

I think I solved this! I changed by conditional formatting rules to numbers instead of percentages.

 

For example, "If greater than or equal to 0 'Number' and is less than 0.95 'Number' then 'Color Red.'" 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors