Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Highlight Changes Week Over Week

Hello. I'm developing a project that involves taking an existing Excel spreadsheet that is manually generated using a database and converting it into Power BI.  For the first iteration, I'd like to ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Anonymous  There's probably a more efficient way but my brain capacity isn't coming up with it today. 

     

    You can create a measure for each column/measure value you want to compare and add conditional formatting. I have done the Manager one for you, just follow the pattern for the Complete and Accepted: 

     

    Week on Week Manager Change =
    VAR _ThisWeek = MAX('Table'[Week Number])
    VAR _Lastweek = _ThisWeek -1
    VAR _valThisWeek =[Manager Name]
    VAR _valLastWeek = CALCULATE([Manager Name], 'Table'[Week Number] = _Lastweek)
    RETURN
    IF(_valThisWeek = _valLastWeek, 0, 1)
     
    PBIX file attached below signature. 
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous  There's probably a more efficient way but my brain capacity isn't coming up with it today. 

 

You can create a measure for each column/measure value you want to compare and add conditional formatting. I have done the Manager one for you, just follow the pattern for the Complete and Accepted: 

 

Week on Week Manager Change =
VAR _ThisWeek = MAX('Table'[Week Number])
VAR _Lastweek = _ThisWeek -1
VAR _valThisWeek =[Manager Name]
VAR _valLastWeek = CALCULATE([Manager Name], 'Table'[Week Number] = _Lastweek)
RETURN
IF(_valThisWeek = _valLastWeek, 0, 1)
 
PBIX file attached below signature.