Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Issue with text values conditional formatting in matrix visual

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=100159507080639555743&rtpof=true&sd=true

 

Thanks in advance!
PaulDBrown  Vvelarde MarcelBeug amitchandak  Greg_Deckler johnt75 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

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

      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.