Forum Discussion
Reg - How to set default range in visual without affecting the slicers
Hi Everyone,
I am trying to display last 4 calender weeks of data in line chart it will show once i used the slider to change the range for two months it will not work..KIndly help me on this issue as soon as possible.
Thanks & regards,
Poornalingam A
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=pnAesWxYgJ8
4 Replies
- amitchandak
Super User
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=pnAesWxYgJ8 Hi
Thank u amitchandak
My requiremets is I have used date slicer for my report and we wants it to default to last 4 weeks on load and later user can change the date range.
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.