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. 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks so much Allison.  This works perfectly.