Power BIHow to set the default value in Report filter pane?
In this blog, we are going to see how to set the default value for value in report filter pane in Power BI.
Sometimes we came with a requirement to set default values in a day filter to Current Month as default.
Since we cannot use DAX in report level filter directly but we can work around this issue in the following way by creating the following DAX
Default Filter = IF(MONTH(Calendar[Date])=MONTH(NOW()) && YEAR(Calendar[Date])=YEAR(NOW()),”This Month”,””)
You can drag the filter in the report level filter and select the value as “This Month”.