Forum Discussion
Filters with default value
Hi all,
i'm new in Power BI, i always worked with Oracle Business Intelligence.
My goal is to set a filter that has a default value. Let's do an example:
- Year: current year
- Month: less or equal to current month
The problem is that the user must have the possibility to change it. For example the report opens with 2019 data but we want to see 2018 data.
Is there a way to do this dynamically?
Thanks,
Francesco
hi, FrancescoSCP
Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.
So for your requirement, it couldn't achieve that set a default value(or maxdate) for a slicer.
and as a workaround, you add a column to judge if the date is current year date then set it in visual/page/report level filter or create a measure do the same work. eg. https://community.powerbi.com/t5/Service/How-to-set-a-time-slicer-to-select-the-latest-date-in-default/td-p/319202
Best Regards,
Lin
1 Reply
hi, FrancescoSCP
Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.
So for your requirement, it couldn't achieve that set a default value(or maxdate) for a slicer.
and as a workaround, you add a column to judge if the date is current year date then set it in visual/page/report level filter or create a measure do the same work. eg. https://community.powerbi.com/t5/Service/How-to-set-a-time-slicer-to-select-the-latest-date-in-default/td-p/319202
Best Regards,
Lin