Slicers affecting matrix visual

Question

I have matrix table which showing weekly data, and a measure which is showing % deviation,&nbsp; a slicers with values week1, week2, week3, when I am selecting week1 in slicers, my %deviation value changes to 0. I want measures value to be remains same

amitchandak · Accepted Answer

Akshaykadam98 , make sure you are using measures like
&nbsp;
Have these new columns in Date Table, Week Rank is Important in Date/Week Table
Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense) ORWeek Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format
These measures can helpThis 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))
&nbsp;
% deviation = divide([this week] - [last week], [last week]) 
&nbsp;
Power BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123https://www.youtube.com/watch?v=pnAesWxYgJ8

Forum Discussion

Slicers affecting matrix visual

2 Replies

Related content

Slicer doesn't affect matrix

Slicer panels affecting bookmarks

Slicer affected by other slicer

CALCULATE with REMOVEFILTERS still affected by slicer

Make visual affect slicer