Forum Discussion
Creating automated default visual filters for end users
Hello!
I have a query regarding the creation of default visual filter for end users in Power BI. For example. I am having below bar chart and timeline filter.
My end user goal is to view the % of members engaged in the last 6 week from the current day. Instead of my users playing with the filter and setting the timelines manually, is there a way in Power BI where I can create a default view/ logic in such a way that, if my users visit the dashboard, the visuals should be updated with last 6 weeks engagements from current date they are viewing.
Any suggestions or approach for this problem will be extremely helpful.
Cheers,
Praj
Hi Praj,
Current power bi does not support setting dynamic default value on slicer. Perhaps you can try it create calculated column to check current date and system date and return flag.
Then you can use it as filter on your report page to filter match records, saving to the bookmark and binding to the button for quick reset filter effects.
Regards,
Xiaoxin Sheng
1 Reply
Hi Praj,
Current power bi does not support setting dynamic default value on slicer. Perhaps you can try it create calculated column to check current date and system date and return flag.
Then you can use it as filter on your report page to filter match records, saving to the bookmark and binding to the button for quick reset filter effects.
Regards,
Xiaoxin Sheng