Issue with text values conditional formatting in matrix visual

[Anonymous]

Hi Everyone,

I'm facing an issue with text values conditional formatting in matrix visual. Please help me with this.

I have two different tables, one is the Live data table and the Previous week's data table.

FYI, Please find the above snapshot.  My requirement is, i need to highlight the changes in live visual which compares to last week. If you can observe that snap shot, the username (Vinod) code will changes in live seet while compare to previous week, now i need to highlight only changes in live visual.

Sample data:- https://docs.google.com/spreadsheets/d/1ywvspnfl7O2DscU7HLRzDPMHd0iYAPwU/edit?usp=share_link&ouid=10...

Thanks in advance!
@PaulDBrown  @Vvelarde @MarcelBeug @amitchandak  @Greg_Deckler @johnt75 

[amitchandak]

@Anonymous , is it possibles to create wow measures using this week vs last week

This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

You need to have a rank column in date/week table

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

[Anonymous]

Thanks for you quick response @amitchandak , but my query is different, i have 2 tables and i need to compare the text valuesb/w both tables and those changes need to highlith in live sheet.