Show Week-over-Week % increase in Matrix visual?

Question

Hi all, I'm trying to show the Week-over-week % increase in a Matrix visualization. I created two Measures for each Metric I want to show, one for Last week, and one for Current week.

Adding this to the Matrix visual, however, is very kludgy and not suitable for what I want. If I remove the Column Grand Totals, the % increase also disappears. It is also very cumbersome to create these measures for each metric. Is there a better way?

CurrWeekUsers = CALCULATE(SUM(data_source[users]), FILTER(google_analytics_4weeks, data_source[week_num]=WEEKNUM(NOW() )))

PreWeekUsers = CALCULATE(SUM(data_source[users]), FILTER(google_analytics_4weeks, data_source[week_num]=WEEKNUM(NOW() )-1))

% Change = ([CurrWeekUsers]  - [PreWeekUsers] )  / [PreWeekUsers]

gilbertq · Answer

Hi there&nbsp;What I would suggest doing is to put all your measures into one measure and then debug them using the variables. You can watch this video by Adam and Marco who explain how to do the debugging.&nbsp;https://www.youtube.com/watch?v=9SV2VnYbgg4&nbsp;&nbsp;I would also suggest creating a Date table, as this makes Time Intelligence measures work.You can find details on how to create it from my blog post here:&nbsp;https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/&nbsp;Then below is the measure that I created on my Google Analytics and it works as expected.&nbsp;%&nbsp;Weekly&nbsp;Change&nbsp;=VAR&nbsp;ThisWeekDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;WEEKNUM&nbsp;(&nbsp;TODAY&nbsp;(),&nbsp;2&nbsp;)VAR&nbsp;LastWeekDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;WEEKNUM&nbsp;(&nbsp;TODAY&nbsp;(),&nbsp;2&nbsp;)&nbsp;-&nbsp;1VAR&nbsp;ThisYear&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;YEAR&nbsp;(&nbsp;TODAY&nbsp;()&nbsp;)VAR&nbsp;CurrWeekUsers&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Users],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date'[Week&nbsp;Number&nbsp;of&nbsp;Year]&nbsp;=&nbsp;ThisWeekDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;'Date'[Calendar&nbsp;Year]&nbsp;=&nbsp;ThisYear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)VAR&nbsp;PrevWeekUsers&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Users],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date'[Week&nbsp;Number&nbsp;of&nbsp;Year]&nbsp;=&nbsp;LastWeekDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;'Date'[Calendar&nbsp;Year]&nbsp;=&nbsp;ThisYear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)VAR&nbsp;PercChange&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;DIVIDE&nbsp;(&nbsp;(&nbsp;CurrWeekUsers&nbsp;-&nbsp;PrevWeekUsers&nbsp;),&nbsp;PrevWeekUsers&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;PercChange

corbusier · Answer

Thank you Gilbert, could you show an example of a chart or matrix visual using this measure? How does it look? For example, in mine, I'd like to display the last 4 weeks but only show the % change once, for the last 2 weeks.&nbsp;

gilbertq · Answer

Hi thereCould you please explain how you would want to display the last 4 weeks but only show the % change for the last 2 weeks?Would this all be on one matrix?

Forum Discussion

Show Week-over-Week % increase in Matrix visual?

3 Replies

Related content

Week over week measure

Week over Week Diff

Week over Week Change

Week over Week Comparison

Year Over Year Increase% by week