Forum Discussion
Reg - How to set default range in visual without affecting the slicers
Anonymous , You can use Week Rank for that. But you might have to use independent table approach in video shared
Approach for trend -https://www.youtube.com/watch?v=duMSovyosXE
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=pnAesWxYgJ8Hi Anonymous ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.Best Regards,
Stephen Tao
Hi Anonymous ,
You could try to use ISFILTERED function. You can put the date column in the slicer into the column name of ISFILTERED(<columnName>). Create the measure as
=IF(ISFILTERED(<DateName>), Result 1, Result2 )
Result 1 is the result when the slicer is filtering, and Result 2 is the result when the slicer is not filtering.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.