Forum Discussion
Make the current month as default value
Greetings, I want to make the current month is a default value for the (date) column. note that I want to make this for different 3 tables, so I tried to make a relation between them on the (date...
Hi Anonymous,
Unfortablely, current power bi does not support setting default value on the slicer.
For your scenario, I'd like to suggest you create a calendar table to link your table date fields. Then you can add a calculated column with if statement to check date value and return tag. After these steps, you can use this tag to choose current month and save to bookmark to quick reset slicer to the 'default value' current month.
Regards,
Xiaoxin Sheng