Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago

Disable specific filter in Visual

Hi experts! I have a bar chart that shows the sales aggregated (total department) for the past on a weekly basis. Then I have a matrix that shows our top 10 product sales. This matrix is filtered o...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

joshua1990 , One of the ways is to create a measure with all('Date'[Week]) or removefilters('date'[Week])

 

calculate([Measure], all('Date'[Week]))

 

Another is to have an independent date table, which is used in the measure of Matrix. This will more be suitable as the bar is showing the weekly trend

 

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8